Skip to main content

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

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.

Back to the full Power BI roadmap