cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors