Cumulative Values by Selected Period

[jayanthan]

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

[v-yuta-msft · Accepted solution]

@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.