Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Running total

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

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , I think you should use all

     

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