Group by criteria

[BYENER]

Hi,

Can someone help me? I have a table with start and end timestamp per processtep per operator. I grouped this data, but the issue is when a operator switched from processtep to another processtep and later back to the first processtep then the group by function take the first time and the last. I need the last time before the operator switch to another processtep. See below 

Operator (operator_id) 2828 started at 08:37:54 with processstep_id 1060. At 09:41:13 he switched to processtep 1073 and at 09:50:05 back to the first processtep 1060. When I group this data I would like to see the next:

Start: 08:37:54 End: 09:36:56 Processtep_id: 1060 Operator: 2828

Start: 09:41:13 End: 09:42:36 Processtep_id: 1073 Operator: 2828

Start: 09:50:05 End: 09:53:02 Processtep_id: 1060 Operator: 2828

[Greg_Deckler]

See if my MTBF works for you. 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/3395...

It has very similar requirements.

[BYENER]

Hi @Greg_Deckler 

Thank you for your reply. I tried it, but it's too difficult to translate your formula to my data :).

Is there another way to do that in PowerQuery instead of DAX?

[BYENER]

Does someone else another solution for me?