-- Time Intelligence Sales PY = CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Date'[Date])) Sales YOY % = DIVIDE([Total Sales] - [Sales PY], [Sales PY])