The Ultimate Power Query Wrapping Shortcut! 🔥😯 | #powerquery #datacleaning #mlanguage

preview_player
Показать описание

In this video, you'll learn how to quickly and effortlessly include double quotation marks, curly braces, or brackets in your queries with just a few keystrokes.

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!
Рекомендации по теме
Комментарии
Автор

I stumbled on this in PQ some time ago. Tried it in Jupyter notebook as well. Neat stuff.

navisalomi
Автор

Chandeep, how important you think mastering power query is if you are a power bi developer? What could be the next step to do at this position?

sd
Автор

Yes, indeed. Use this with ( all the time. It is essential for my way of writing formulas.
Two remarks:
• Doesn’t work with the closing bracket, etc. ;-)
• It does something completely different in Excel Classic. :-(

GeertDelmulle
Автор

I eliminate all spaces after coding without". The code looks much cleaner.

silverfunnel
Автор

How can I shift a symbol which is already an upper case symbol?
" ⇒ shift+2
( ⇒ shift+8 😥

RogerStocker