The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!
California | Michigan | |
120 Days | 150 | 175 |
90 Days | 200 | 235 |
60 Days | 250 | 295 |
30 Days | 300 | 355 |
14 Days | 350 | 415 |
7 Days | 400 | 475 |
3 Days | 450 | 535 |
Event | 500 | 595 |
Post Event | 550 | 655 |
Total | 3150 | 3735 |
@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
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:
California | Michigan | California | Michigan | ||
120 Days | 150 | 175 | 150 | 175 | |
90 Days | 200 | 235 | 350 | 410 | |
60 Days | 250 | 295 | 600 | 705 | |
30 Days | 300 | 355 | 900 | 1060 | |
14 Days | 350 | 415 | 1250 | 1475 | |
7 Days | 400 | 475 | 1650 | 1950 | |
3 Days | 450 | 535 | 2100 | 2485 | |
Event | 500 | 595 | 2600 | 3080 | |
Post Event | 550 | 655 | 3150 | 3735 |