Forum Discussion
Solved
Resetting my cumulative total when it dips below zero
Hi I have a cumulative sum that has a starting total which then needs to be adding a Loadingtotal. this loading total could be positive or negative. if the cumulitive sum goes below zero it shoul...
Hi zbrooks ,
This approach is built in Power Query, so the calculation is done during data load. Because of that, it won’t respond to slicers or filters applied in the report the values will remain static regardless of user interaction.
If you need the cumulative total to change dynamically based on slicers, then the same logic would need to be implemented using a DAX measure instead.
Hope this helps.
Thank you.
Hi zbrooks ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you
Hi zbrooks ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.