← Back to Tools
DAX

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. 1

    Introduction to DAX

    Measures, and how DAX differs from a spreadsheet formula.

  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.

Start learning — it's free →

DAX is free to study, self-paced. Pass the final exam to earn an optional Certificate of Completion for $40.