Guide Dax !exclusive! May 2026
-- Time Intelligence Sales PY = CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Date'[Date])) Sales YOY % = DIVIDE([Total Sales] - [Sales PY], [Sales PY])
-- Time Intelligence Sales PY = CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Date'[Date])) Sales YOY % = DIVIDE([Total Sales] - [Sales PY], [Sales PY])