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

     

Sean's avatar
Sean
Community Champion
10 years ago

spencer_g This should work! Let me know...

 

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