Skip to main content
cancel
Showing results for 
Search instead 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.

Reply
Shinooj
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-MonthCountRunning Total(Expected Output)
2021-Jan1010
2021-Feb2030

2021-Mar

030
2021-Apr232
2021-May1547
2021-Jun148
2021-Jul1058
2021-Aug1371
2021-Sep071

 

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-MonthCountRunning Total(Expected Output)
2021-Apr232
2021-May1547
2021-Jun148
2021-Jul1058
2021-Aug1371
2021-Sep071
2 REPLIES 2
Wilson_
Solution Sage
Solution Sage

Hi Shinooj,

 

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

 

Wilson__1-1681479863797.png

 

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

Alf94
Super User
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,

Helpful resources

Announcements
Microsoft Fabric Learn Together

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

April Fabric Community Update

Fabric Community Update - April 2024

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

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

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

Top Solution Authors