cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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 Specialist

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

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors