Here are a few more for the advanced editor: • Alt+Shift+A: toggle block comment • Ctrl+M: toggle tab key behaviour • Alt+click: select multiple text input locations (for simultaneously editing text in all selected locations) • F7 and Shift+F7: go to next / previous (applies to the highlighted text, e.g. definition) • Ctrl+0: reset zoom to 100% Also: • I can use Tab and Shift+Tab to increase/decrease text indentation Note: as often is the case, the keyboard layout may affect the shortcut keys. Hence, there’s no guarantee that they will work with the keyboard layout you’re using.
Hi Goodly, those are awesome shortcuts, is there any shortcut to when you're done working with the advanced editor to press it instead of clicking on the "Done" button to return to power query?
Hi is there a formula or PQ way to change any transactions time that come between 12:00:00 AM and 7:59:59 AM To be 8:00:00 AM which is the start of working hour.
It's really useful! But I have a question. When I create a query on the desktop step-by-step, then the applied steps are listed one-by-one. However, after I use the advanced editor to create a new step, then the applied steps are no longer displayed. Could anyone please give me some advice?
Awesome !! please make one video on , How to select right chart in power Bi ? I often get confused while selecting chart in power Bi. Please make one video with real cases. Waiting Curiously.
That one is very interesting. It shows the code of the previous step you selected. So if you first selected query step 1, and are now in step 10, it shows the code of step 1. And if you were at step 3 before, and now at step 10, then Alt + Backspace shows the code from step 3. Nice find!
Here are a few more for the advanced editor:
• Alt+Shift+A: toggle block comment
• Ctrl+M: toggle tab key behaviour
• Alt+click: select multiple text input locations (for simultaneously editing text in all selected locations)
• F7 and Shift+F7: go to next / previous (applies to the highlighted text, e.g. definition)
• Ctrl+0: reset zoom to 100%
Also:
• I can use Tab and Shift+Tab to increase/decrease text indentation
Note: as often is the case, the keyboard layout may affect the shortcut keys. Hence, there’s no guarantee that they will work with the keyboard layout you’re using.
Hi Goodly, those are awesome shortcuts, is there any shortcut to when you're done working with the advanced editor to press it instead of clicking on the "Done" button to return to power query?
Very useful! Thanks
Hi Chandeep, again super. Would you know by any chance the code in a German Excel version as ctrl+/ seems not to be working. Thanks
I wish M-code had the same Ctrl+Shift+L to select all instances of a highlight word like DAX
Many thanks Chandeep! The zoom in functionality is useful
Glad you liked it
Wow, I'm so excited 🥳👍
I'm going to stick Post-Its on my monitors again, like in the good old days 😉
welche tastatur verwendest du?
Hi is there a formula or PQ way to change any transactions time that come between 12:00:00 AM and 7:59:59 AM To be 8:00:00 AM which is the start of working hour.
Hi there! do you know how to search text inside the M Code?
Text.Contains
It's really useful! But I have a question.
When I create a query on the desktop step-by-step, then the applied steps are listed one-by-one. However, after I use the advanced editor to create a new step, then the applied steps are no longer displayed. Could anyone please give me some advice?
Hi Chandeep, Please make video on complete M Language formulas...
Hi, that was a quick response to my request (last week). Thanks!
Hope you like it!
How do these work for European keyboards?
I am not able to find advance editor option in view tab . please help me
Awesome !!
please make one video on , How to select right chart in power Bi ? I often get confused while selecting chart in power Bi. Please make one video with real cases. Waiting Curiously.
try playing this game - goodly.co.in/pick-the-right-chart-game/
When I press Alt + Backspace in the advanced editor PQ, something strange happens. Try pressing these keys and see what this combination does?
That one is very interesting. It shows the code of the previous step you selected. So if you first selected query step 1, and are now in step 10, it shows the code of step 1. And if you were at step 3 before, and now at step 10, then Alt + Backspace shows the code from step 3. Nice find!
Awesome.. as always! Thanks!!
Glad you like it!
This is same as DAX code editing in Power BI. It is mentioned at the end too...
Very nice!
Thanks!
Thanks..useful ones 👍👍
Glad you like it!
Very nice. Thanks for sharing!
Glad you like it!
Excellent👌
Thank you! Cheers!
Useful, useful, useful.
Glad it was useful!
I’m glad someone else asks if they entered a forward slash. LOL
Hey, two seconds is two seconds! 😂
Yes! 😉