topic Running Total Column based on Index that resets every time there is a zero in DAX Commands and Tips

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

mlapu — Wed, 14 Jul 2021 16:10:32 GMT

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.

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

Jihwan_Kim — Wed, 14 Jul 2021 17:22:16 GMT

Link to the pbix file

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

mlapu — Wed, 14 Jul 2021 17:59:20 GMT

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!