Build your own YoY quick measure
Time to bring it all together to calculate the YoY change! Remember the YoY chart from chapter 2, where you used a Quick measure? By now, you have the knowledge to create a YoY change calculation from scratch! You will calculate a Total Sales YoY%
measure, which will calculate the % difference between the total sales this year and the previous year. Note that you won't calculate a year-to-date value in this exercise.
If you have lost any progress, close any open reports and load 4_3_yoy.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
