Tool
DAX
The formula language behind Power BI measures
Learn DAX measures, filter context, and time intelligence.
8
Chapters
17
Hours (estimated)
1
Self-paced
Part-time
About 6 weeks
1 hour a day, 3 days a week
Full-time
About 2 weeks
3 hours a day, 3 days a week
Estimated from 8 chapters (notes, practice, labs, quiz, exercise, and challenge) plus the final exam. Go at your own pace.
Curriculum
8 chapters, each with a tutorial, a live example, a quiz, an exercise, a challenge, and class practice.
- 1
Introduction to DAX
Measures, and how DAX differs from a spreadsheet formula.
- 2
Calculated Columns vs Measures
When to use each, and why it matters.
- 3
Filter Context
How visuals and slicers shape a calculation.
- 4
CALCULATE Function
Modifying filter context explicitly.
- 5
Time Intelligence
Year-to-date, prior period, and date functions.
- 6
Iterators (SUMX, etc)
Row-by-row calculations across a table.
- 7
Variables in DAX
VAR/RETURN for readable, efficient measures.
- 8
Common Patterns
Ranking, running totals, and % of total.
DAX is free to study, self-paced. Pass the final exam to earn an optional Certificate of Completion for $40.