Forum Discussion
Running Total Reset after specific column change
Hello,
I would like to have a running total that is reset when a value (Job in this case) changes, but keeping another group of information (entryDate, in this case). I would specifically like to do this in Power Query and not in DAX, if possible. Below is an example of the input and RunningTotal being the ideal output.
| Job | EntryDate | HoursWorked | RunningTotal | |
| 60004 | 8/21/2015 12:00:00 AM | 1 | 1 | |
| 60004 | 7/2/2015 12:00:00 AM | 12.4 | 13.4 | |
| 60004 | 7/8/2015 12:00:00 AM | 14.99028 | 28.39027767 | |
| 60005 | 7/15/2015 12:00:00 AM | 18.59222 | 18.592222 | Running Total Reset |
| 60005 | 7/18/2015 12:00:00 AM | 4.7475 | 23.339722 | |
| 60005 | 7/8/2015 12:00:00 AM | 9 | 32.339722 | |
| 60005 | 7/1/2015 12:00:00 AM | 29.7625 | 62.10222211 | |
| 60005 | 7/7/2015 12:00:00 AM | 18 | 80.10222211 | |
| 60005 | 7/10/2015 12:00:00 AM | 9.948333 | 90.05055511 | |
| 60005 | 7/13/2015 12:00:00 AM | 10 | 100.0505551 | |
| 60006 | 7/17/2015 12:00:00 AM | 10 | 10 | Running Total Reset |
| 60006 | 7/20/2015 12:00:00 AM | -20.2786 | -10.27861111 | |
| 60006 | 7/23/2015 12:00:00 AM | 21.29417 | 11.01555578 | |
| 60006 | 6/30/2015 12:00:00 AM | 8.404444 | 19.42000022 | |
| 60006 | 7/9/2015 12:00:00 AM | 9 | 28.42000022 | |
| 60006 | 7/29/2015 12:00:00 AM | 16.17722 | 44.59722244 |
Any Advice / Solutions already created?
Thanks for the help!
Anonymous
Please check the attached file below my signature:
2 Replies
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!
