Forum Discussion
Calculate duration between 2 rows
Hello, I want to be able to establish the time between events for the same Work order and apply this delay to the next work center. Here is an example of the data and what I want to do : Init...
See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586
Thanks Greg, your MTBF calculation is really nice. I will surely use it.
If I understand correctly, it would gives me the average time after an event. In my case it's a little bit more complicated since I wanted to establish the time before the event.
I need to find out for each row to which work center the part is going in order to use your calculations. I can then make the average based on the "Next work center"
Regards,