Calculating difference in time in different rows

Hi BorisTPL ,

According to your needs, I did the following test, first get the time corresponding to the Estimate field, and then get the difference in turn, refer to the following:

Column =
VAR last_time =
    CALCULATE (
        MAX ( 'Table'[TimeStatusChange] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[workerID] = EARLIER ( 'Table'[workerID] )
                && 'Table'[workorderStatus_name] = "Estimate"
        )
    )
RETURN
    DATEDIFF ( last_time, 'Table'[TimeStatusChange], MINUTE )

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

BorisTPL , try column like

new column =
var _max =maxx(filter(Table, [workorder ID] = earlier([workorder ID]) && [datetime] <earlier([timestatus change])),[timestatus change])
return
[timestatus change] -_max

or

new column =
var _max =maxx(filter(Table, [workorder ID] = earlier([workorder ID]) && [datetime] <earlier([timestatus change])),[timestatus change])
return
datediff(_max,[timestatus change] , minute)

The second one almost did it! However, the time is not in the correct row as shown below:

The time the workorder had status "Estimate" (5669 minutes) is shown in the row with status "Under repair". Do you maybe have a tip how to correct the formula to shift it to the right row? Thank you amitchandak 

Code:

Dear v-henryk-mstf , thank you for your reply.

I tried using your code to check if it would result in the desired output, but unfortunalty it does not. I get the same output as you have posted above but this is not the amount of minutes that it took for each status to get to the next one. This calculates the amount of minutes between status estimate and another status.
My desired output would look like this: 

So what I think could be a solution, is taking the Datediff(Next Status change, current status change) instead of looking at the last status change. However I can't find a similar function like Earlier() but in the opposite direction, so if you know a way how to create a variable that takes the Next status change instead of the last status, I would be more than happy to hear

Also, the workorders do no always follow the same 'route'. This one is just an example. Sometimes there is not even a status 'estimate', so it would be better not too specify what the status_name is in the calculation. It should just look at the time diff between the next and the current status, regardless of what status it is.