Subtract date from different rows

[Anonymous]

Hi,

I would like to calculate the difference in days (if possible even just working days Mon-Fri) from two dates.

Each order has different operations and I have the transaction date for each of them.

This is one example order but I have many more in the table.

Now I need to calculate operation (DJPLGR): R01471 = 20180922 - 20180918 = 4 days. How can I do that?

As an addition, I want to calculate the total time max DJTRDT - min DJTRDT and compare it to lead time (MBLEAT).

Thank you for your help.

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/Finding-the-previos-occurrence-within-same-table-based-on-one/m-p/342607#M153516