Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
JoseCuevas
Regular Visitor

Cumulative Total from meged query column

JoseCuevas_0-1601500906973.png

in the list, rather than have 1,0, 1,1,1,... i would like t have 1,1,2,3,4,... 

a cumulative sum.

1 ACCEPTED SOLUTION

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] ) ))

View solution in original post

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.