Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
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
Proud to be a 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.
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.
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
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.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |