subtract row values based status

[cleytonp]

I need to subtract a value from one row from another based on status.
this is my current table situation.

I would like a new column with the same values ​​as below.

[v-yetao1-msft · Accepted solution]

Hi @cleytonp 

If the value in recording column is displayed in your current order and hierarchy, you can refer to my method .

(1)Create a calculated column to return the previous recording.

Previous recording = CALCULATE(MAX('Table'[recording ]),FILTER('Table','Table'[recording ]<EARLIER('Table'[recording ])))

(2)Create a measure with IF() to judge the status .If the status is 1 ,then calculate the diff between two columns .

diff =
var diff='Table'[recording ]-'Table'[Previous recording]
return IF('Table'[status]=0,diff)

(3)Convert diff date/time format to time format.

The final result is as shown :

I have attached my pbix file ,you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

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