Measure to find the Cumulative Sum Values

[Anonymous]

Hi, I have two fields in my table. YYYY-MM which the year and month details. Due amount which has the due amount that is yet to come for respective year and month.

I need a Measure to find the Cumulative value which add the previous due amounts till the end. The first month will start with same due amount and from the next month the due amount gets added one by one.

Please help me to create a measure with DAX.

YYYY-MM	Due Amount	Cumulative Value
2021-01	1000	1000
2021-02	2000	3000
2021-03	3000	6000
2021-04	4000	10000
2021-05	5000	15000

[V-lianl-msft · Accepted solution]

Hi ,

Please try:

Measure = SUMX(FILTER(ALLSELECTED('Table'),'Table'[YYYY-MM] <= MAX('Table'[YYYY-MM]) ),  'Table'[Due Amount])

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous ,

a new column = sumx(filter(Table, [YYYY-MM] = earlier([YYYY-MM]) ),  [Due Amount])

a new measure= sumx(filter(allselected(Table), [YYYY-MM] = max([YYYY-MM]) ),  [Due Amount])