Forum Discussion
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 | 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 |
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!!
1 Reply
- VahidDM
Super User
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!!