Menu
CoddyTech
Start learning

Month over Month Growth

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

Growth from the month before: change divided by the month before.

MoM % = DIVIDE([Revenue] - [Revenue PM], [Revenue PM])

100 after 80 is 25%. A plain subtraction gives the change itself.

challenge icon

Challenge

The model has Revenue PM. Write MoM %: Revenue minus Revenue PM, divided by Revenue PM. It is checked for each month of each year.

bugsy Main icon

Start this challenge with Coddy's AI tutor

What is Bugsy?

All lessons in Time Intelligence

1Dates and Calendars

The Date TableCounting DaysWeekdays and WeekendsFirst and Last DatesRecap - Revenue per Day

2Totals That Grow

Year to DateDATESYTD Inside CALCULATEQuarter to DateRunning TotalRecap - Customers So Far

3Comparing Periods

Same Period Last YearGrowth Year over YearThe Month BeforeMonth over Month GrowthThe Last 7 DaysThe Last 3 MonthsRecap - Year to Date Growth