DAX for Power BIs
DAX, short for Data Analysis Expressions, is the formula language used in Power BI to create measures, calculated columns and calculated tables. Measures are evaluated at query time in the current filter context, which is why the same formula gives different results in different visuals. DAX runs on top of the data model.
Stage: DAX and Analytics · Part of the Power BI roadmap · Last reviewed 19 November 2026
What to learn in DAX
- Write a measure with SUM, DIVIDE and COUNTROWS for totals and ratios
- Explain row context versus filter context with a worked example
- Change filter context using CALCULATE and FILTER
- Calculate year-to-date and previous-year values with time intelligence functions
- Use variables with VAR and RETURN to make a measure readable
DAX interview questions
What is the difference between a calculated column and a measure in DAX?
A calculated column is computed row by row at refresh and stored in the model, using memory. A measure is computed on demand in the current filter context and stores nothing. Use measures for aggregations and columns when you need a value to slice by.
What does CALCULATE do in DAX?
CALCULATE evaluates an expression after modifying the filter context. You pass it a measure and one or more filters, and it adds, replaces or removes filters before computing. It is the core function behind time intelligence and most conditional measures.
Where DAX fits in the Power BI roadmap
DAX belongs to the DAX and Analytics stage (beginner level), which takes about 14 hours. Calculations.
Other units in this stage
Back to the full Power BI roadmap