Forum Discussion
Running Total Reset after specific column change
- 5 years ago
Anonymous
Please check the attached file below my signature:
I did so much research on "running total by group with reset in this column". It was amazing to see there are so many different ones out there but just couldn't find anything close to what I'm trying to accomplish.
Thank you so much for providing a download attachment for it. It helps alot on understanding how you set it up. I did follow step by step as what you provided above BUT would like to add a reset into it. The running total is adding up just like how you have it set up, but I would like for it to reset to 0 once it recognizes the "Yes" in the “Reset?” column and then start adding the running total from there. Here is a screen shot below. The top picture is what I currently have in my power bi query editor while bottom picture is what I would like for it do it. Please let me know if this is possible. Thank you!