DAX, the language of Power BI, may seem like an easy thing to learn on the surface. You probably have already created a few reports or dashboards here and there, helping your organizations make data driven decisions. But you're also probably limited to just basic calculations such as SUM or AVERAGE, etc. And sometimes, your reports produce head scratching results that you just can't seem to figure out why. 

Well, you have come to the right place as we can help you get over that hump. We all have been in your shoes before, trying to learn Power BI and DAX on our own. But we ended up wasting so much time trying to search for a solution online whenever we needed to create more advanced reports. Sometime, we got lucky and found similar people in the same boat, but most of the time we had to throw in the towel, which we missed out on potentially adding more values to our companies. 

By taking our DAX course, you will learn the fundamentals and techniques that will enable you to quickly handle and develop any Power BI requests thrown at you.

This course contains 4 hours of video lessons and 28 total exercises.

Course curriculum

  • 1

    Downloads

    • Exercises

    • DAX Slides
  • 2

    Welcome to the course!

    • Before we begin...
  • 3

    Chapter 1 - The Basics

    • Lesson 1 - Data Type

    • Lesson 2 - Calculated Columns

    • Lesson 3 - Measures

    • Lesson 4 - Calculated Columns vs Measures

    • Lesson 5 - Aggregated Functions

    • Lesson 6 - X Functions

    • Lesson 7 - Logical Functions Part 1

    • Lesson 8 - Logical Functions Part 2

    • Lesson 9 - Date Time Functions

    • Lesson 10 - Variables

    • Lesson 11 - SELECTEDVALUES

    • Exercise
  • 4

    Chapter 2 - Relationships

    • Lesson 1 - Relationships Intro

    • Lesson 2 - RELATED and RELATEDTABLE

    • Exercise
  • 5

    Chapter 3 - Evaluation Context

    • Lesson 1 - Evaluation Context Intro
  • 6

    Chapter 4 - CALCULATE

    • Lesson 1 - CALCULATE Intro

    • Lesson 2 - Boolean Filter Limitations

    • Lesson 3 - FILTER

    • Lesson 4 - FILTER as a Variable

    • Lesson 5 - ALL

    • Lesson 5 - ALL

    • Lesson 6 - ALLEXCEPT

    • Lesson 7 - VALUES

    • Lesson 8 - ALLSELECTED

    • Lesson 9 - Context Transition

    • Lesson 10 - Context Transition Part 2

    • Lesson 11 - USERELATIONSHIP

    • Exercise
  • 7

    Chapter 5 - Advanced Iterators

    • Lesson 1 - VALUES Part 2

    • Lesson 2 - Top Customers Part 1

    • Lesson 3 - Top Customers Part 2

    • Lesson 4 - Average Daily Sales

    • Lesson 5 - RANKX

    • Lesson 6 - RANKX In Measures

    • Lesson 7 - Top 3 Customers

    • Exercise
  • 8

    Chapter 6 - Time Intelligence

    • Lesson 1 - Time Intelligence Intro

    • Chapter 6 - YTD QTD MTD

    • Chapter 6 - SAMEPERIODLASTYEAR

    • Chapter 6 - DATEADD PARALLELPERIOD

    • Chapter 6 - DATESINPERIOD

    • Chapter 6 - LASTNONBLANK

    • Exercise
  • 9

    Next steps

    • Before you go...