Part of the Analytify BI Glossary, clear definitions of the business intelligence, analytics, and modern data stack terms that matter.
DAX (Data Analysis Expressions) is a formula and expression language developed by Microsoft for use in Power BI, Excel Power Pivot, and SQL Server Analysis Services Tabular models — designed for defining calculated columns, measures, and tables in tabular data models that power dashboards and BI reports.
DAX is the language behind every measure, calculation, and KPI in a Microsoft Power BI dashboard. If your organisation is on Power BI, DAX literacy is the difference between basic dashboards and powerful analytical models. DAX skills are also one of the largest investments that Microsoft-stack BI users make — and one of the largest sources of vendor lock-in.
For organisations evaluating Power BI alternatives, the DAX investment is often a reason to stay or a reason to switch. Modern open-source BI platforms increasingly use SQL or dbt-based modelling, which is more portable than DAX.
DAX has three primary use cases inside a tabular data model:
FullName = Customer[FirstName] & " " & Customer[LastName]Total Revenue = SUM(Sales[Amount]) or more complex: YoY Revenue = CALCULATE([Total Revenue], DATEADD(Date[Date], -1, YEAR))DAX has hundreds of functions across categories: aggregation (SUM, AVERAGE, COUNTROWS), filter (FILTER, CALCULATE, ALL), time intelligence (DATEADD, DATESYTD, SAMEPERIODLASTYEAR), iterator (SUMX, AVERAGEX), and logical (IF, SWITCH).
DAX is notoriously hard to learn well. The CALCULATE function — DAX’s most powerful feature — modifies filter contexts in ways that confuse even experienced practitioners.
A Power BI dashboard tracks year-over-year revenue growth. The DAX measure: YoY Growth % = DIVIDE([Total Revenue] - CALCULATE([Total Revenue], SAMEPERIODLASTYEAR(Date[Date])), CALCULATE([Total Revenue], SAMEPERIODLASTYEAR(Date[Date]))). This single expression handles year-over-year comparisons across any date filter the user applies. The equivalent in SQL would require window functions and CTE wrangling — DAX makes time intelligence concise once you understand the filter context model.
2026 DAX tool landscape:
Primary use case for DAX. Both Power BI Desktop and Power BI Service support DAX measures.
DAX inside Excel’s data model. Common for finance teams.
Enterprise BI platform that uses DAX for calculations.
Standalone tool for writing, testing, and optimising DAX queries.
Advanced DAX modelling tool for Power BI / Analysis Services.
DAX is used to define calculated columns, measures, and tables in tabular data models — typically in Power BI dashboards, Excel Power Pivot models, and SQL Server Analysis Services. It powers the calculations behind every Power BI dashboard.
No. SQL queries databases. DAX defines calculations inside an in-memory tabular model. DAX has filter contexts and row contexts that have no equivalent in SQL.
DAX’s filter context model is non-obvious. The CALCULATE function — central to almost any non-trivial measure — modifies filter contexts in ways that surprise beginners. Most DAX developers say it took months to “get” filter contexts.
Generally no. DAX is a Microsoft language tied to the tabular model. If you switch from Power BI to another BI tool, your DAX measures are not portable; they have to be rewritten in the new tool’s language (typically SQL or LookML).
M language (Power Query) is for data transformation and loading — extract and reshape source data. DAX is for calculations on data already loaded into the tabular model. Power BI uses both: M to load and transform, DAX to compute measures.
If your organisation is on Power BI, yes — DAX literacy multiplies your value. If you are evaluating BI tools, consider that DAX investment is not portable. SQL + dbt skills transfer across all modern BI tools.