Forum Discussion
Solved
Cumulative Total from meged query column
in the list, rather than have 1,0, 1,1,1,... i would like t have 1,1,2,3,4,...
a cumulative sum.
- Adding a column and following those instructions did not work, but adding a measure ( like below ) worked great.**bleep** referral 2 =CALCULATE(SUM(vDiscipline_Forecast[incident_ind] ) ,FILTER(ALLSELECTED( vDiscipline_Forecast[incident_date] ) ,vDiscipline_Forecast[incident_date] <= MAX( vDiscipline_Forecast[incident_date] ) ))
2 Replies
- d_gosbell
Super User
If you google for "Power Query Running Total" you will find a bunch of different examples. The following is one of the simpler ones https://www.sumproduct.com/blog/article/power-query-blogs/power-query-one-route-to-a-running-total
- Adding a column and following those instructions did not work, but adding a measure ( like below ) worked great.**bleep** referral 2 =CALCULATE(SUM(vDiscipline_Forecast[incident_ind] ) ,FILTER(ALLSELECTED( vDiscipline_Forecast[incident_date] ) ,vDiscipline_Forecast[incident_date] <= MAX( vDiscipline_Forecast[incident_date] ) ))
