Loading comparison...
Loading comparison...
Data Analysis Expressions for Microsoft Power BI, Analysis Services, and Power Pivot formula calculations.
DAX (Data Analysis Expressions) is a formula and query language developed by Microsoft for its business intelligence ecosystem, introduced alongside PowerPivot in 2009. It serves as the calculation engine for Power BI, SQL Server Analysis Services (SSAS) Tabular models, and Excel Power Pivot, enabling analysts to create custom measures, calculated columns, and complex business calculations over tabular data models. DAX operates on a columnar, in-memory data engine (VertiPaq) that processes millions of rows with sub-second response times.
The language combines elements familiar to Excel users — functions like SUM, AVERAGE, and IF — with powerful concepts from database query languages including filter context, row context, and context transition through CALCULATE. Mastering DAX requires understanding evaluation contexts, a concept unique to the language that determines how formulas interpret data based on filters, slicers, and row iterations. Time intelligence functions built into DAX handle common business calculations like year-over-year growth, running totals, and moving averages without manual date manipulation.
The language's CALCULATE function is considered the most important and complex function, enabling dynamic filter modification that powers sophisticated analytical scenarios. Organizations from small businesses to Fortune 500 companies rely on DAX for executive dashboards, financial reporting, and operational analytics. The SQLBI team (Marco Russo and Alberto Ferrari) has produced extensive educational resources that have become the de facto standard for DAX learning.
DAX formula diffs are high-impact because measure changes directly alter executive dashboards and business reports consumed by decision-makers. Subtle modifications to CALCULATE filter arguments, context transitions, or time intelligence functions can produce incorrect KPIs without obvious errors.
Data analysts and BI developers should compare DAX files during measure refactoring, report migrations, and when multiple team members modify shared data models.
UtraDiff compares DAX formula files with syntax highlighting that color-codes measure definitions, CALCULATE functions, filter context modifiers, and table references. Side-by-side view reveals how business logic calculations change between versions — modified SUMX iterations, altered FILTER conditions, and updated variable declarations stand out clearly.
Inline view consolidates nested function call changes. Alt+arrow navigation jumps between modified measures, helping Power BI developers review formula evolution.
Supported extensions: .dax .msdax