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.
Why DAX (Data Analysis Expressions) Matters
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.
How DAX (Data Analysis Expressions) Works
DAX has three primary use cases inside a tabular data model:
- Calculated columns: Add a derived column to a table.
FullName = Customer[FirstName] & " " & Customer[LastName] - Measures: Define aggregations evaluated at query time.
Total Revenue = SUM(Sales[Amount])or more complex:YoY Revenue = CALCULATE([Total Revenue], DATEADD(Date[Date], -1, YEAR)) - Calculated tables: Create derived tables from formulas.
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.
Real-World Example
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.
Common DAX (Data Analysis Expressions) Tools and Platforms in 2026
2026 DAX tool landscape:
Microsoft Power BI
Primary use case for DAX. Both Power BI Desktop and Power BI Service support DAX measures.
Excel Power Pivot
DAX inside Excel’s data model. Common for finance teams.
SQL Server Analysis Services Tabular
Enterprise BI platform that uses DAX for calculations.
DAX Studio (free)
Standalone tool for writing, testing, and optimising DAX queries.
Tabular Editor (free / paid)
Advanced DAX modelling tool for Power BI / Analysis Services.
Frequently Asked Questions About DAX (Data Analysis Expressions)
What is DAX used for?
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.
Is DAX the same as SQL?
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.
Why is DAX hard to learn?
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.
Can DAX be used outside Microsoft tools?
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).
What is the difference between DAX and M language?
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.
Should I learn DAX in 2026?
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.