Forum Discussion

spencer_g's avatar
spencer_g
Helper I
10 years ago
Solved

Cumulative Sum

I posted yesterday, and have since resolved part of the original problem, but I am still trying to figure out how to create a cumulative sum for 3 years of data.    I am trying to create a line cha...
Need Help
  • MR2001's avatar
    MR2001
    10 years ago

    I had a similar issue, and would suggest a small modification:

     

    1. Add a slicer on field (choose a filed in your table)

    2. Cumulative Employers = CALCULATE(sum('I Employers'[Employer Count]),(FILTER(ALL('I Employers'[Date Created]), 'I Employers'[Date Created] <= "2020-12"), VALUES(field))) 

     

spencer_g's avatar
spencer_g
Helper I
10 years ago

Thanks for your response. I figured it was that [Date Created] was text, so I used the original data which was saved as a date, [Org Date Created], and put it into the formula you recommended:

 

Cumulative Employers = CALCULATE(sum('I Employers'[Employer Count]),(FILTER(ALL('I Employers'[Org Date Created]), 'I Employers'[Org Date Created] <= MAX('I Employers'[Org Date Created]))))

 

However, I still come up with the same result. The line graph is cumulated by year, but not each year buildling upon the year before it. 

 

Vvelarde's avatar
Vvelarde
Community Champion
10 years ago

spencer_g

 

Try this

 

Cumulative Employers = CALCULATE(sum('I Employers'[Employer Count]),(FILTER(ALL('I Employers'), 'I Employers'[Org Date Created] <= MAX('I Employers'[Org Date Created]))))