Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Cumulative total

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 ...
  • VahidDM's avatar
    VahidDM
    4 years ago

    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!!

     

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

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!!