Forum Discussion
Asa94
3 years agoHelper I
Cumulative/Running Total calculation with a condition
Hi all,
I hope you're all well.
I'm currently building a call centre report and one of the visuals is a "Total Open Calls" visual.
For this visual, I need to calculate the number of total open calls at the beginning of the new/current day n:
- All open calls have a status of 0, while closed is 100
- At any given day, new calls come in and calls are close
- The "Total Open Calls" calculation is:
- All calls from all previous days (status=0) + new calls [day n-1] (status=0) - closed calls [day n-1] (status=100)
I need to showcase it in the image below:
I tried using the rolling total calculation and the results are only for the latest date. Whereas, the visual needs to showcase to date.
Any help and tips will be greatly appreciated 🙂
Kind Regards,
Asa
1 Reply
- Greg_DecklerCommunity Champion
Asa94 See if this helps: Better Running Total - Microsoft Power BI Community