Forum Discussion
Cumulative Values by Selected Period
Hi All
How can we create Cumulative Value by Selected Year
E.g Based on below given data
when i select year 2018, i should get cumulative value 10,24,45 for months 1,2,3
When i select year 2019 ,i should get cumulative value 40,70,110 for months 1,2,3
| Year | Month | Value | Cumulative |
| 2018 | 1 | 10 | 10 |
| 2018 | 2 | 15 | 25 |
| 2018 | 3 | 20 | 45 |
| 2019 | 1 | 40 | 40 |
| 2019 | 2 | 30 | 70 |
| 2019 | 3 | 40 | 110 |
Regards
Jayanthan
Create a calculate column as below:
Cumulative = CALCULATE(SUM('Table'[Value]), FILTER('Table', 'Table'[Year] = EARLIER('Table'[Year]) && 'Table'[Month] <= EARLIER('Table'[Month])))Then you can create a slicer based on year column to filter table visual:
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Create a calculate column as below:
Cumulative = CALCULATE(SUM('Table'[Value]), FILTER('Table', 'Table'[Year] = EARLIER('Table'[Year]) && 'Table'[Month] <= EARLIER('Table'[Month])))Then you can create a slicer based on year column to filter table visual:
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.