Calculate Time Span - difference in current row minus previous row.

[Kumar Shanmugam]

I am using power BI desktop.

I wanted to get previous row value and then the difference current row - previous row value.

Timespan: What is the time difference in cutting receipts by a person (collected by)

I wanted to create new column Previous collected DTM where values of row preceding the current Collection DTM will be entered.

Then create another column where Collection DTM minus Previous collection DTM.

Data is sorted by combo:

 

[Chihiro]

Refer to my post in link below for how to refer to previous row in PQ.
Third post (heading 2. How to refer to previous row in PowerQuery)
https://chandoo.org/forum/threads/useful-powerquery-tricks-chihiros-notes.35658/

If you need further help, please upload sample data (Excel workbook is fine).

 

[GraH - Guido]

Or as an alternative to referring to previous row, you can:

1. add an index "starting from 1"
   
2. add a second index "starting from 0"
3. merge the table to itself: link index 1 to index 0
   
4. Extract the new data
5. do a (nested) if to calculate the difference between DTM and DTM.1 where collected by matches collected by.1

 

[GraH - Guido]

Made a sample (in Excel) with some small improvements (merge on 2 keys and use simple time subtraction from UI) from previous post.

 

[Kumar Shanmugam]

Thanks this works