DAX
Course Index
28 Lessons · 3 Sections
Master DAX — Data Analysis Expressions, Power BI's formula language. Covers CALCULATE, iterators & DAX Studio optimisation across Power BI, Excel Power Pivot & Analysis Services. Includes 4 builds: sales KPI model, time intelligence measures, budget vs actual report & optimised DAX measure.
28Lessons
3Sections
4Projects
FreeAccess
Section 1DAX FundamentalsLessons 1–10
Lesson 1
What is DAX? Data Analysis Expressions Overview
Lesson 2
DAX Syntax: Measures vs Calculated Columns
Lesson 3
DAX Basic Functions: SUM, COUNT, AVERAGE & DIVIDE
Lesson 4
DAX Filter Functions: FILTER, ALL & ALLEXCEPT
Lesson 5
CALCULATE: The Most Important DAX Function
Lesson 6
Time Intelligence: DATEADD, SAMEPERIODLASTYEAR
Lesson 7
RELATED & RELATEDTABLE: Cross-Table Lookups
Lesson 8
Iterator Functions: SUMX, AVERAGEX & COUNTX
Lesson 9
Variables in DAX: VAR & RETURN
Lesson 10
Ranking & Sorting with DAX: RANKX
Section 2Advanced DAX & OptimisationLessons 11–22
Lesson 11
DAX for YTD, QTD & MTD Calculations
Lesson 12
DAX for Rolling Averages & Moving Windows
Lesson 13
DAX for Cohort & Retention Analysis
Lesson 14
Semi-Additive Measures in DAX
Lesson 15
DAX for Budget vs Actual Variance
Lesson 16
What-If Parameters & Scenarios in DAX
Lesson 17
Row Context vs Filter Context in DAX
Lesson 18
DAX Studio: Debugging & Optimisation
Lesson 19
VertiPaq Engine & DAX Performance
Lesson 20
DAX in Power BI vs Analysis Services vs Excel
Lesson 21
Advanced DAX: TREATAS, USERELATIONSHIP & CROSSFILTER
Lesson 22
DAX in 2026: Copilot & New Functions
Section 3Anti-Patterns, Best Practices & ProjectsLessons 23–28