Get startedGet started for free

Use of SAMEPERIODLASTYEAR()

Another very common time intelligence calculation is the year-over-year (YoY) calculation, where a certain measure (e.g. sales) is compared between this year and the previous year. A first step to calculate the YoY of a measure, is to calculate the value of that same measure exactly one year ago. This is where the SAMEPERIODLASTYEAR() function comes into play.

If you have lost any progress, close any open reports and load 4_2_sameperiodlastyear.pbix from the Exercises folder on the desktop.

This exercise is part of the course

Intermediate DAX in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise