Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise