Cumulative total

[Anonymous]

Hi All,

I want to calculate the cumulative value for below table.

Month	Actual
September	0.4
October	4.0
November	0
December	0
January	0
February	0
March	0
April	0
May	0
June	0
July	0
August	0

The expected output should be like below, I have data only for the month September and October. My Trendline should show all the months and the cumulative data should be calculated till month.

Month	Actual	Cumulative
September	0.4	0.4
October	4.0	4.4
November	0	0
December	0	0
January	0	0
February	0	0
March	0	0
April	0	0
May	0	0
June	0	0
July	0	0
August	0	0

[VahidDM · Accepted solution]

Hi @Anonymous 

add a column with this code:

Month No. = 
month(DATEVALUE("2021/"&[Month]&"/01"))

then try this measure:

Cumulative 1 = 
Var _A =CALCULATE(sum('Table'[Actual]),filter(all('Table'),'Table'[Month No.]<=max('Table'[Month No.])))
return
if(max('Table'[Actual])=0,0,_A)

output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!