Menu
CoddyTech
Start learning

Running Total

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

A running total adds every date so far, with no restart.

Running Revenue = CALCULATE([Revenue], FILTER(ALL(Dates), Dates[Date] <= MAX(Dates[Date])))

MAX(Dates[Date]) is the row's last day; ALL(Dates) removes the row's date filters; FILTER keeps the dates up to that day.

challenge icon

Challenge

Write Running Revenue: Revenue over every date up to the end of each row. 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