DAX

Curriculum

8 chapters, each with a tutorial, a live example, a quiz, an exercise, a challenge, and class practice.

1. 1

   Introduction to DAX

   Measures, and how DAX differs from a spreadsheet formula.

   preview
2. 2

   Calculated Columns vs Measures

   When to use each, and why it matters.

3. 3

   Filter Context

   How visuals and slicers shape a calculation.

4. 4

   CALCULATE Function

   Modifying filter context explicitly.

5. 5

   Time Intelligence

   Year-to-date, prior period, and date functions.

6. 6

   Iterators (SUMX, etc)

   Row-by-row calculations across a table.

7. 7

   Variables in DAX

   VAR/RETURN for readable, efficient measures.

8. 8

   Common Patterns

   Ranking, running totals, and % of total.