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

     

Baskar's avatar
Baskar
Resident Rockstar
10 years ago

Hi Spence_g

 

I suggest two ways for you.

 

1. Use the original measure without creating calculate measure, then u could apply the visual level filter as

"'I Employers'[Date Created]" and choose  year should greater or less then which u want.

 

2. Cumulative Employers = CALCULATE(sum('I Employers'[Employer Count]),(FILTER(ALL('I Employers'[Date Created]),

Year('I Employers'[Date Created]) >= 2001 )))  -- Here change the year whatever you want.

 

it will work , check it if not let me know i will be assist u .....