Have a running total continue past year

[CarlSagan]

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.

[some_bih · Accepted solution]

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!