DAX Same Period Last Year Sales Measure

Re-evaluates sales over the equivalent period one year earlier.

Time IntelligenceIntermediatesameperiodlastyearyear over yearcomparison

DAX code

Same Period Last Year Sales =
-- SAMEPERIODLASTYEAR assumes the current selection is one contiguous period;
-- prefer DATEADD('Date'[Date], -1, YEAR) (see Previous Year Sales) if that isn't guaranteed
CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Date'[Date]))

Generate a Power BI date table

Notes

Behaves like Previous Year Sales for most simple selections, but can differ for irregular, non-contiguous date selections.

Requirements

A proper Date dimension table marked as the model's date table.

Builds on these measures

How to use this measure

In Power BI Desktop, select the table that should hold the measure and choose New measure on the ribbon.
Paste the code, then replace the placeholder table and column names with your own. The My table names fields above do this for you.
Run it through the DAX Formatter if you want it laid out in your team's style.

Related DAX measures

More DAX resources

Browse all 175 measures in the Power BI DAX Measures Library, or search the library for something similar to Same Period Last Year Sales.