cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper IV

Measure to find the Cumulative Sum Values

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.

 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
1 ACCEPTED SOLUTION
Community Support

Hi ,

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

2 REPLIES 2
Community Support

Hi ,

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

Super User

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

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.