Practice DAX on a realistic company’s data.
Write measures in your browser on the Brightline Supply Co. model, from SUM and CALCULATE to time intelligence. Every answer is checked against the true numbers. Free to start, no sign-up.
The first 5 Power BI exercises are free. See pricing
How it works
- 1
Get a real request
Your manager needs a number for a report. The model is already loaded: orders, products, customers, targets and a date table.
- 2
Write the measure
Type DAX in the editor and see it fill a matrix, with filters and a slicer, just like a report page.
- 3
Exact feedback
Every row and the total are compared with the true answer. A miss tells you what is off, never the answer.
Includes AI audits: an assistant wrote the measure, and you find the mistake.
What you will practise
- The data model7 exercises
Relationships, filter direction, the Date table, SUM and COUNTROWS
- Your first measures7 exercises
AVERAGE, MIN, MAX, DISTINCTCOUNT, DIVIDE, measures built on measures
- CALCULATE and filters8 exercises
Filter arguments, AND/OR, IN, replacing a filter vs KEEPFILTERS, FILTER
- Totals and % of total7 exercises
ALL, REMOVEFILTERS, ALLEXCEPT, share of the total
- Iterators8 exercises
SUMX, AVERAGEX, MAXX, context transition
- Related tables7 exercises
RELATED, RELATEDTABLE, LOOKUPVALUE
- Calculated columns6 exercises
Columns on a table, bands with SWITCH(TRUE())
- Time intelligence9 exercises
YTD and QTD, DATEADD, SAMEPERIODLASTYEAR, rolling 3 months, vs target
- Variables and logic6 exercises
VAR and RETURN, SWITCH, BLANK and COALESCE, HASONEVALUE
- Ranking and top N6 exercises
RANKX with skip and dense ties, rank within a category, TOPN
Same data, every tool
The same company data runs through the Excel and SQL tracks, and every plan includes all three.