What is DAX (Data Analysis Expressions)?
DAX (Data Analysis Expressions) is the formula language of Power BI, Analysis Services and Power Pivot, used to define metrics and calculated columns in the data model. With DAX, aggregations, time comparisons and context-dependent calculations are created that respond dynamically to filters in reports.
Also known as: Data Analysis Expressions · DAX formulas · measures
Where DAX is used
DAX calculates metrics within a finished data model, such as revenue, margin, year-over-year comparisons or moving averages. Unlike a simple Excel formula, DAX takes the evaluation context into account: a metric automatically returns the appropriate result depending on the selected filter, period or segment.
A central concept is the difference between measures (calculated at query time, very flexible) and calculated columns (computed on load, stored in the model). Functions such as CALCULATE control the filter context and are the heart of advanced DAX calculations.
Typical use cases
DAX is used wherever reports need more than plain sums.
- Metrics such as revenue, margin or utilization as reusable measures
- Time intelligence: year-over-year, year-to-date, moving averages
- Context-dependent calculations that respond to filters and slicers
- Ratio and share metrics across multiple dimensions
How it relates & how smiit uses it
DAX is the calculation language in the model, not the data preparation; connecting and reshaping the data is done by Power Query, and the underlying data layer is the semantic model. Well-modeled data (such as a clean star schema) makes DAX considerably simpler and faster. In the dy Project AG data platform, clearly defined DAX metrics ensure that all reports use the same definitions. smiit values traceable, performant DAX measures over nested one-off formulas that no one maintains anymore.
Common mistakes & misconceptions
- DAX is not a variant of Excel formulas; it works with filter context and relationships across entire tables, not individual cells.
- Many confuse calculated columns and measures. Columns are stored row by row, while measures are computed at query time within the current filter context.
- A common error is to treat understanding row and filter context as optional. That context is the most frequent cause of wrong DAX results.
Frequently asked questions
What is the difference between a measure and a calculated column?
A measure is calculated at query time in the respective filter context and is very flexible. A calculated column is computed on load and stored in the model, which uses more memory and is less dynamic.
Is DAX hard to learn?
The basics are quick to learn, similar to Excel formulas. DAX becomes demanding with the filter context and functions such as CALCULATE; here a clean data model and experience, such as smiit contributes, help.
What is the difference between Power Query and DAX?
Power Query prepares the data before it is loaded into the model, that is connecting, cleansing and reshaping. DAX then calculates metrics and aggregations within the finished data model. The two complement each other but solve different tasks.
Why is a good data model important for DAX?
DAX calculates in the context of the model's tables and relationships. A clean star schema with clear relationships makes measures simpler, faster and easier to follow, whereas a tangled model leads to complicated formulas and performance problems.
Related terms
Sources & further reading
Want to put this topic to work in your company?
Updated · Back to the glossary