Running Total Reset after specific column change

[djkirkma]

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!

[patbyr]

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!

[Fowmy · Accepted solution]

@djkirkma 

Please check the attached file below my signature: