Menu
CoddyTech
Start learning

The Last 3 Months

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

DATESBETWEEN(Dates[Date], start, end): the dates from start to end.

EOMONTH(date, -3) + 1 is the first day of the month two months back.

Last 3 Months = CALCULATE([Revenue], DATESBETWEEN(Dates[Date], EOMONTH(MAX(Dates[Date]), -3) + 1, MAX(Dates[Date])))

May covers March, April and May.

challenge icon

Challenge

Write Last 3 Months: Revenue of the row's month and the two before it. It is checked for each month of each year.

bugsy Main icon

Start this challenge with Coddy's AI tutor

What is Bugsy?
quiz iconTest yourself

This lesson includes a short quiz. Start the lesson to answer it and track your progress.

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