Growth Year over Year

Part of the Time Intelligence section of Coddy's Power BI journey. Lesson 12 of 17.

Growth = (this year - last year) / last year.

YoY % = DIVIDE([Revenue] - [Revenue LY], [Revenue LY])

120 against 100 is 20%. A drop is negative.

A new store has a blank last year, and DIVIDE gives blank.

Challenge

The model has Revenue LY. Write YoY %: Revenue minus Revenue LY, divided by Revenue LY. The table is filtered to 2025; it is checked for each store.

Start this challenge with Coddy's AI tutor

What is Bugsy?

All lessons in Time Intelligence

1Dates and Calendars

The Date Table Counting Days Weekdays and Weekends First and Last Dates Recap - Revenue per Day

2Totals That Grow

Year to Date DATESYTD Inside CALCULATE Quarter to Date Running Total Recap - Customers So Far

3Comparing Periods

Same Period Last YearGrowth Year over YearThe Month Before Month over Month Growth The Last 7 Days The Last 3 Months Recap - Year to Date Growth