Forum Discussion
bourne2000
5 years agoHelper V
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
- FowmySuper User
bourne2000
In Power Query, First Select Delivery Column then the Order Column. Under Add Column Tab, select Time then Subtract: