Cumulative Sum not working??

[ShemRo]

Hi There,

I have the below dataset.

I am wanting to calculate a cumulative total of the act column. I am making a mistake in my calculated column somwhere in the code:

Cumulative_Act_Hours_Col = CALCULATE(SUM('Table'[act]),Filter(All('Table'[MonthYear]),'Table'[MonthYear]<=EARLIER('Table'[MonthYear])))

Any helpwould be greatly appreciated. I have done similar formulas before but this one has got me stumped.

Thanks in advance.

[VahidDM]

Hi @ShemRo 

What is your "MonthYear" column format? it seems it's not date/time!

Check that and then if it's not Date format change that to Date format and check your formula again.

Cumulative_Act_Hours_Col = CALCULATE(SUM('Table'[act]),Filter(All('Table'),'Table'[MonthYear]<=EARLIER('Table'[MonthYear])))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[ShemRo]

That it what i orginally thought too but...

regards Shem

[VahidDM · Accepted solution]

Oh Ok.

Have you tried this:

Cumulative_Act_Hours_Col =
CALCULATE(
SUM( 'Table'[act] ),
FILTER( ALL( 'Table' ), 'Table'[MonthYear] <= EARLIER( 'Table'[MonthYear] ) )
)

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[ShemRo]

Ahh yes!!! Thanks so much. This got it. it was the 'Table' after the ALL that i had incorrect.

Thank you so much!!

[Anonymous]

This is quick and simple. 

cumulativeAmt = VAR _dateScope=MAX('Table'[dt])
return CALCULATE(SUM([act]),ALL('Table'),'Table'[dt]<=_dateScope)

[ShemRo]

Thanks @Anonymous 

..Hmm... something is off as mine only sum and dont accumulate: