Running Total Column based on Index that resets every time there is a zero

[mlapu]

Hello,

I'm trying to find the maximum time that a piece of equipment has been running. When the equipment is running, the "Startup" column indicates a 1. When it is shut off, the "Startup" column shows a zero. I would like to find the total time it ran before it had to be shut off again, which would eventually be used in a graph showing the maximum run times (my Final Values). Note that it is not being referenced by a date, but only an index!

Hopefully someone out there can help!

Thank you.

[Jihwan_Kim · Accepted solution]

Link to the pbix file 

[mlapu]

Hi Jihwan_Kim,

The response looks like it would work, but I am getting an error saying there isn't enough memory to calculate! my dataset is about 20k rows. But I agree this looks like it would work. Thank you!