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.

Frequent Visitor

Running Total Expression

I am trying to calculate the Running total of Backlog count of tickets . I am gettting the Total But there is a requirement : If i am selecting any month then First i need to cumilate the Data up to that month and need to show the Backlog trend from that point .

Please find the Sample data and Expected output Below .

 Year-Month Count Running Total(Expected Output) 2021-Jan 10 10 2021-Feb 20 30 2021-Mar 0 30 2021-Apr 2 32 2021-May 15 47 2021-Jun 1 48 2021-Jul 10 58 2021-Aug 13 71 2021-Sep 0 71

By Default The Table should Show Running Total Heirarchy from 2021-Jan to 2021-Sep , But If i am selecting the Month From 2021-Apr The Table should change as below . Please help on this .

 Year-Month Count Running Total(Expected Output) 2021-Apr 2 32 2021-May 15 47 2021-Jun 1 48 2021-Jul 10 58 2021-Aug 13 71 2021-Sep 0 71
2 REPLIES 2
Solution Sage

Hi Shinooj,

I've uploaded a sample pbix here. This is what my report page looks like.

I believe this is what you're looking for. Let me know if you have any questions about my solution.

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

Super User

Hi @Shinooj

Could you please try the following?

``````Running total =
SUMX(
WINDOW(
1, ABS,
0, REL,
ALL( Table[Year-Month] ),
ORDERBY( Table[Year-Month], ASC )
),
CALCULATE( SUM( Table[Count] ) )
)``````

If this measure works, please mark my answer as a solution to help people with the same question as you in the future.

Best,

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

Fabric Community Update - April 2024

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

Power BI Monthly Update - March 2024

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

Top Solution Authors
Top Kudoed Authors