The essential Power Bi Dax Common Patterns cheat sheet: 6 concise chapters you can read in minutes, distilled from the full deck. When you're ready, drill the flashcards or test yourself under exam conditions.
The most important distinction in DAX is between a calculated column and a measure. A calculated column is evaluated row by row at refresh time, stored inside the model, and operat...
Read full chapter →CALCULATE is the single most important function in DAX. It evaluates an expression under a modified filter context, replacing or adding filters as specified in its arguments. A pat...
Read full chapter →Time intelligence in DAX requires a properly configured date table. Mark a table as the date table in the Modeling tab, ensure it contains a continuous, unique list of dates with n...
Read full chapter →Iterator functions evaluate an expression for each row of a table and then aggregate the results. SUMX(Sales, Sales[Quantity] * Sales[UnitPrice]) multiplies quantity by unit price...
Read full chapter →Calculation groups let you define reusable transformation patterns that apply to any measure on a visual. For example, a single calculation group can define YTD, prior year, and mo...
Read full chapter →Best practices for measure authoring begin with avoiding implicit measures. Power BI auto-creates aggregations for numeric columns, which leads to inconsistent behavior, missing fo...
Read full chapter →Done reading?
Test yourself with the Power Bi Dax Common Patterns practice exam — timed questions, instant score, full review of wrong answers. Free.
🎯 Take the Practice Exam →