Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
@bourne2000
In Power Query, First Select Delivery Column then the Order Column. Under Add Column Tab, select Time then Subtract:
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@bourne2000
In Power Query, First Select Delivery Column then the Order Column. Under Add Column Tab, select Time then Subtract:
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
88 | |
88 | |
74 | |
67 | |
58 |
User | Count |
---|---|
136 | |
110 | |
91 | |
84 | |
69 |