Forum Discussion

bourne2000's avatar
bourne2000
Helper V
5 years ago
Solved

How to find the time difference between two columns?

Hi

 

I have a two-time column called order time and delivery time. I need to find the time difference between the two columns to check how long it would take to deliver the order

 

 

How to calculate the time difference in Power Query or DAX? Prefer to do it in Power Query. I took the difference but it's not coming correctly. Please advise.

 

  • bourne2000 

    In Power Query, First Select Delivery Column then the Order Column. Under Add Column Tab, select Time then Subtract:

     

1 Reply

  • bourne2000 

    In Power Query, First Select Delivery Column then the Order Column. Under Add Column Tab, select Time then Subtract: