Practisheet
New

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