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]...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , I think you should use all

 

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