Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
bourne2000
Helper V
Helper V

How to find the time difference between two columns?

‎05-22-2021 02:17 AM

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

 

bourne2000_0-1621674955792.png

 

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.

 

Labels:
Message 1 of 2
406 Views
0
1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

‎05-22-2021 02:28 AM

@bourne2000 

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

Fowmy_0-1621675714496.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group

View solution in original post

Message 2 of 2
400 Views
1 REPLY 1
Fowmy
Super User
Super User

‎05-22-2021 02:28 AM

@bourne2000 

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

Fowmy_0-1621675714496.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group

Message 2 of 2
401 Views

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

View All