Menu
CoddyTech
Start learning

The Last 7 Days

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

DATESINPERIOD(Dates[Date], end, -7, DAY): seven days ending on a day.

Last 7 Days = CALCULATE([Revenue], DATESINPERIOD(Dates[Date], MAX(Dates[Date]), -7, DAY))

10 January covers 4 to 10 January. The window moves with the rows and smooths the line.

challenge icon

Challenge

Write Last 7 Days: Revenue over the 7 days ending on each row's day. It is checked day by day for January 2025.

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