Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lastnn30
Post Patron
Post Patron

Shortcut of Subtracting Times in Power Query

Hi

I have Start Time and End Time columns and I want to subtract EndTime - StartTime, in power query. I selected both of them and I know if I go to the Ribbon -->Add Column -->Time -->Subtract

 

But the Subtract option is not available (or that what I think) if I use the shortcut which is Right Clicking on the Field to see all the option. So my question, how can I do the Subtract using shortcut?

 

SNAG-0700.jpg

2 ACCEPTED SOLUTIONS
PhilipTreacy
Super User
Super User

Hi @lastnn30 

 

If the option isn't there when you right click then you can't do it that way.

 

Why not just use the Ribbon method?

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

Vijay_A_Verma
Super User
Super User

Right clicking a column offers options from whatever Transformation menu can offer. It doesn't offer options from Add Column menu. Since Transformations menu doesn't offer Subtract time option, hence you can't subtract this way. 

View solution in original post

4 REPLIES 4
Vijay_A_Verma
Super User
Super User

Right clicking a column offers options from whatever Transformation menu can offer. It doesn't offer options from Add Column menu. Since Transformations menu doesn't offer Subtract time option, hence you can't subtract this way. 

Thank you very much.

PhilipTreacy
Super User
Super User

Hi @lastnn30 

 

If the option isn't there when you right click then you can't do it that way.

 

Why not just use the Ribbon method?

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


I just thought it must be a shortcut for that too. I do not mind the ribbon but it can be confusing sometime and the right click is life saver actually. Thank you very much.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.