Subtract between two row in the same column via Custom Column

[Hossam]

Hello 

Id like to subtract these two values  to get the amount of minutes the order took from statues pending to statues in kitchen via a custom column

[Anonymous · Accepted solution]

@Hossam 

You can do it in dax with an easy calculate column then change the format to TIME.

Column = IF([Status after]="in_kitchen",[Created at] - CALCULATE(MAX('Table'[Created at]),FILTER('Table',[ID]=EARLIER([ID])-1)))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Hossam , Create a new column like

new column =
var _min = maxx(filter(Table, [order_id] = earlier([order_id]), [created_date] <earlier([created_date]) && [Status_after] = "pending"),[created_date])
return
if([Status_after] = "in_kitchen", datediff(_min, [created_date], minute))

[Hossam]

Hello, @amitchandak I want to do this for all of the rows no matter what the statues are because its a whole process of statues.

so basically I want to subtract the second row of the column created at with the cell above it

Think you Can help me?