Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

How to show a running-total instead of a total for a Matrix?

In a similar report to this I can get Sales Total (value) for each bucket.  But they are only specific to the sales in that number of days.  How do I do a running-total so 90 days shows Sales for itself + 120 days, and so forth?  Thanks!

 

 CaliforniaMichigan
120 Days150175
90 Days200235
60 Days250295
30 Days300355
14 Days350415
7 Days400475
3 Days450535
Event500595
Post Event550655
Total31503735
2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , Not very clear. But create measures for all these and use a calculation group to combine these

 

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Thanks for your effort, let me try to clear up.  All the values in the column for the buckets are specific Sales totals.  So my measure adds up all sales by day for the specific time interval and then displays it.  Where I am struggling is instead of showing the Total Sales for the bucket I need to have it as a running-total so it keeps adding the values going down.  Hope this clears it up.  So it would look like this instead:

 

 CaliforniaMichigan CaliforniaMichigan
120 Days150175 150175
90 Days200235 350410
60 Days250295 600705
30 Days300355 9001060
14 Days350415 12501475
7 Days400475 16501950
3 Days450535 21002485
Event500595 26003080
Post Event550655 31503735

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors