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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
