Cummulative sum of last 48 values

[Dunner2020]

Hi there,

I have got sales values. I want to create a column, which contains the cumulative/running sum of the last 48 sales values. Any help in this regard would be really appreciated.

Regards

Yasir

[Anonymous · Accepted solution]

Hi,

You should add an index column to the table if you don't already have it. Just a click in Power Query.

Then something like this:

NewColumn =
VAR CurrentIndex = 'Table'[Index]
RETURN
    CALCULATE (
        SUM ( 'Table'[ColumnToSum] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Index] > CurrentIndex - 48
                && Table[Index] <= CurrentIndex
        )
    )