Running total

[Anonymous]

Hi all,

I would like to add the values before February 21 to the running total.

I've this running total measure:

CALCULATE(SUM([id]),

FILTER(ALLSELECTED('calendar'),

'calendar'[dateid] <= Max('alendar'[dateid])))

BUT I want to calculate like this

Feb-21: before February 21 to the running total + Feb-21

Mar-21: before February 21 to the running total + Feb-21 + Mar-21

Thanks in advance

[amitchandak]

@Anonymous , I think you should use all

CALCULATE(SUM([id]),
FILTER(ALL('calendar'),
'calendar'[dateid] <= Max('alendar'[dateid])))