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?
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.
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?
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.
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
Very useful! Thanks
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 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, that was a quick response to my request (last week). Thanks!
Hope you like it!
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
Hi Chandeep, Please make video on complete M Language formulas...
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/
I’m glad someone else asks if they entered a forward slash. LOL
Very nice. Thanks for sharing!
Glad you like it!
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.
How do these work for European keyboards?
Thanks..useful ones 👍👍
Glad you like it!
Very nice!
Thanks!
Excellent👌
Thank you! Cheers!
This is same as DAX code editing in Power BI. It is mentioned at the end too...
Hi there! do you know how to search text inside the M Code?
Text.Contains
Awesome.. as always! Thanks!!
Glad you like it!
Useful, useful, useful.
Glad it was useful!
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?
I am not able to find advance editor option in view tab . please help me
Hey, two seconds is two seconds! 😂
Yes! 😉
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!