FreeLevel 3 · Professional

Power BI DAX

Power BI Fundamentals taught you to write measures. This course teaches you to write measures you can trust and explain. Working on Kolanut Distribution's sales model, you'll learn how DAX really evaluates a formula (filter context, row context and context transition), then use CALCULATE to build shares of a total, a category and a selection. You'll write time intelligence that stays honest when a year is incomplete, split growth into price and volume with variables, count customers that meet a condition with table functions, rank customers and products, and build active, lapsed and Pareto customer measures. The course ends with performance tuning, a testing routine and a commercial dashboard for Kolanut's leadership.

About 7 hours
11 modules
1 badge
Final project
Optional verified certificate

Curriculum

01How DAX ThinksSet up the Kolanut model you'll use all course, write the base measures every report builds on, and learn the habits that keep a measure library trustworthy.25 min
02Filter Context and Row ContextThe two ways DAX decides which rows a formula sees, and context transition, the rule that explains most "why is every row the same number?" mysteries.25 min
03IteratorsCalculate row by row and then aggregate, choose the right "average of what", and use RELATED to bring values from a dimension into the loop.25 min
04CALCULATE in DepthHow CALCULATE adds, replaces and removes filters, and how to build shares of a total, of a category and of what the user selected.25 min
05Variables, BLANKs and Readable DAXUse VAR and RETURN to write measures you can read and debug, handle BLANK on purpose, and split revenue growth into price and volume.25 min
06Time IntelligenceYear-to-date, same period last year, month-on-month and rolling totals, plus the like-for-like fix that stops a part year from looking like a collapse.25 min
07Table FunctionsBuild tables inside a measure with FILTER, VALUES, SUMMARIZE and ADDCOLUMNS, count the customers that meet a condition, and test your tables in DAX query view.25 min
08Ranking and Top NRank customers and products with RANKX, handle ties and totals, measure how concentrated sales are with TOPN, and let report users choose N.25 min
09Customer Analytics PatternsActive and lapsed customers over a rolling window, Pareto concentration and ABC classes, and headcount on a date, built from patterns you can reuse on any data.25 min
10Performance and TestingFind slow visuals with Performance Analyzer, rewrite the DAX patterns that cause them, and test measures against the source data before anyone else sees them.25 min
11Final ProjectPlan your final project, a DAX-driven commercial dashboard for Kolanut's leadership, and warm up with three of its measures.20 min
Final assessmentPass it (60% or more) to earn the Power BI DAX course completion badge.

Skills you'll learn

Filter context, row context and context transition
Iterators: SUMX, AVERAGEX, MAXX and RELATED
CALCULATE, KEEPFILTERS, REMOVEFILTERS, ALLEXCEPT and ALLSELECTED
Variables, BLANK handling and readable DAX
Like-for-like time intelligence
Table functions: FILTER, VALUES, SUMMARIZE and DAX query view
Ranking with RANKX and TOPN
Active, lapsed, new customers and Pareto analysis
Performance Analyzer and testing measures

Before you start

Power BI Fundamentals, or comfort with Power Query, relationships and simple measures
Power BI Desktop (free, Windows only)

Final project

Kolanut commercial dashboard

Badges and certificate

Earn a free course completion badge with its own credential ID and public page you can share. Learning and badges are always free.

After you finish, you can choose to get an official verified PDF certificate. It's optional. How it works

Loading…

Power BI DAX

About 7 hours

11 modules

1 badge

Final project

Optional verified certificate

Curriculum

01How DAX ThinksSet up the Kolanut model you'll use all course, write the base measures every report builds on, and learn the habits that keep a measure library trustworthy.25 min

02Filter Context and Row ContextThe two ways DAX decides which rows a formula sees, and context transition, the rule that explains most "why is every row the same number?" mysteries.25 min

03IteratorsCalculate row by row and then aggregate, choose the right "average of what", and use RELATED to bring values from a dimension into the loop.25 min

04CALCULATE in DepthHow CALCULATE adds, replaces and removes filters, and how to build shares of a total, of a category and of what the user selected.25 min

05Variables, BLANKs and Readable DAXUse VAR and RETURN to write measures you can read and debug, handle BLANK on purpose, and split revenue growth into price and volume.25 min

06Time IntelligenceYear-to-date, same period last year, month-on-month and rolling totals, plus the like-for-like fix that stops a part year from looking like a collapse.25 min

07Table FunctionsBuild tables inside a measure with FILTER, VALUES, SUMMARIZE and ADDCOLUMNS, count the customers that meet a condition, and test your tables in DAX query view.25 min

08Ranking and Top NRank customers and products with RANKX, handle ties and totals, measure how concentrated sales are with TOPN, and let report users choose N.25 min

09Customer Analytics PatternsActive and lapsed customers over a rolling window, Pareto concentration and ABC classes, and headcount on a date, built from patterns you can reuse on any data.25 min

10Performance and TestingFind slow visuals with Performance Analyzer, rewrite the DAX patterns that cause them, and test measures against the source data before anyone else sees them.25 min

11Final ProjectPlan your final project, a DAX-driven commercial dashboard for Kolanut's leadership, and warm up with three of its measures.20 min

Final assessmentPass it (60% or more) to earn the Power BI DAX course completion badge.

Skills you'll learn

Filter context, row context and context transition

Iterators: SUMX, AVERAGEX, MAXX and RELATED

CALCULATE, KEEPFILTERS, REMOVEFILTERS, ALLEXCEPT and ALLSELECTED

Variables, BLANK handling and readable DAX

Like-for-like time intelligence

Table functions: FILTER, VALUES, SUMMARIZE and DAX query view

Ranking with RANKX and TOPN

Active, lapsed, new customers and Pareto analysis

Performance Analyzer and testing measures