Question

You maintain a Power BI model with a fact table Sales, a properly marked Date table, and an existing measure [Total Sales] = SUM(Sales[Amount]). Management wants a measure that returns the difference between current-period sales and the same period exactly one year earlier, so it works correctly when users filter by any month, quarter, or year on a matrix visual. Which DAX definition should you use?

Accepted Answer

Sales YoY Var = [Total Sales] - CALCULATE([Total Sales], DATEADD('Date'[Date], -1, YEAR))

Answer

Sales YoY Var = [Total Sales] - CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Date'[Date]) - 365)

Answer

Sales YoY Var = [Total Sales] - CALCULATE([Total Sales], FILTER(ALL('Date'), 'Date'[Year] = MAX('Date'[Year]) - 1))

Answer

Sales YoY Var = [Total Sales] - PREVIOUSYEAR('Date'[Date])