topic Re: Have a running total continue past year in DAX Commands and Tips

Have a running total continue past year

CarlSagan — Fri, 07 Jul 2023 17:37:00 GMT

I'm having trouble with computing a running total that gets pased the filter context on year in a matrix. Is it possible to have the value of January 1992 be the sum of December 1991 plus January 1992? I don't know how to get it past the year filter.

The first column is the normal sum amount that power bi computes, the second column the running total measure I am trying to have continue into the next year.

Re: Have a running total continue past year

some_bih — Fri, 07 Jul 2023 20:20:00 GMT

Hi CarlSagan

Check link https://www.sqlbi.com/articles/computing-running-totals-in-dax/

Sales RT :=

VAR MaxDate = MAX ( 'Date'[Date] ) -- Saves the last visible date

RETURN

CALCULATE (

[Sales Amount], -- Computes sales amount

'Date'[Date] <= MaxDate, -- Where date is before the last visible date

ALL ( Date ) -- Removes any other filters from Date

)

Did I answer your question? Mark my post as a solution! Kudos Appreciated!