Sales YoY % = VAR CurrentSales = SUM(Sales[Amount]) VAR PrevYearSales = CALCULATE( SUM(Sales[Amount]), SAMEPERIODLASTYEAR('Date'[Date]) ) RETURN DIVIDE( CurrentSales - PrevYearSales, PrevYearSales )
is a formula language specifically designed for working with tabular data models. Unlike Excel formulas that work on cell references, DAX works exclusively on columns and tables . guide dax
Data Analysis Expressions, commonly known as , is the powerhouse language that fuels data modeling in Microsoft Power BI, Analysis Services, and Power Pivot for Excel. While it may look similar to Excel formulas at first glance, DAX operates on an entirely different logic—moving from simple cell references to complex table and column-level calculations. Sales YoY % = VAR CurrentSales = SUM(Sales[Amount])