Sum Rolling Last 5 rows of dates

[Anonymous]

Hello everyone,

I have an issue and i'm stuck.

I try to make a sum of PTS of the last fives dates. As you can see, it's rolling by the following dates. 

For the rows 5,4,3,2,1 . I'm just making a cumulate until I have 5 rows of dates. 

Thanks a lot for your help.
Regards

Kevin

[Greg_Deckler · Accepted solution]

OK, so I did this:

Index = COUNTROWS(FILTER('Table',[date] <= EARLIER([date])))

And then this:

Rolling 5 Last Days = 
    VAR __Count = COUNTROWS(FILTER('Table',[date] <= EARLIER([date])))
    VAR __Min = [Index] - 5 + 1
RETURN
    IF(
        __Count >= 5,
        SUMX(FILTER('Table',[Index] >= __Min && [Index] <= EARLIER([Index])),[PTS]),
        SUMX(FILTER('Table',[date] <= EARLIER([date])),[PTS])
    )

PBIX is attached.

[Anonymous]

Hi Greg,

You're my hero ! I was tearing my hair all this time.

Thank you very much

Kevin

[Greg_Deckler]

Hmm, trickier than the average bear, let me take a look.