Evolution / Cumulative Sum

[Anonymous]

Been struggling with this one:

I need to show the evolution of notes that have been closed based on weeks:

First week is null because it doesn't have an ending date, then I consider the note as open.

I mean, in the first column, week "13" the result should be: 2380, in week "14" the result should be "2272"... and it goes like this, decreasing until it gets to this date, wherein the result value should be 1715.

[jdbuchanan71 · Accepted solution]

Hello @Anonymous 

You can calculate a running total then subtract that from your full total.

RT Notes = 
    VAR CurrentWeek = MAX ( Notes[Week] )
RETURN
    CALCULATE(
        SUM ( Notes[Notes] ),
        ALL ( Notes[Week] ),
        Notes[Week] <= CurrentWeek
    )

[Anonymous]

Can't seem to thank you enough!!!!!!

It worked perfectly.