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...
Hi Anonymous ,
You could refer to my sample for details. In addition, I don't understand the logic of second result table, could you please explain this to me?
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The second result table comes from the average of the 1st result table. For exemple, the first work order when to the work center A2 2 times and waited 26 hours the 1st time and 74 hours the 2nd time, which gives an average of 50 hours.
Also, I can't open your .pbix since I'm only using the Power Pivot complement in Excel.
| Part# | Next work center | Next operation | Average of Duration between |
| A1S | A1 | 40 | 26:00 |
| Average A1 | 40 | 26:00 | |
| A2 | 20 | 26:00 | |
| A2 | 20 | 74:00 | |
| Average A2 | 20 | 50:00 | |
| A3 | 30 | 26:00 | |
| A3 | 30 | 50:00 | |
| Average A3 | 30 | 38:00 | |
| Total A1S | 40:24 | ||
| Total | 40:24 |
Dominic