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] ) ))
d_gosbell
Super User
Super UserIf 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] ) ))