Power Query Formula Help

Need help with your Power Query "M" language functions and formulas?
🔽 Expand to see more info 🔽
Here’s 3 ways to get started:

00:37 Tip on adding Blank Query to Quick Access Toolbar
01:04 Create a small table using {1..10}
01:29 The Custom Column URL link
02:27 The Formula Bar method
03:26 #shared

Follow me on LinkedIn

Twitter

Access Analytic Training

[MM-nrnf]

You made my day...it's saving lot of googling time.

[gef]

About the intellisense bug, I was even more angry than you when it happens. But I found that the bug seems caused by the dot. Typing the beginning or middle part of the function name without the dot works for me.

[KagnaraRa]

This is really life saving. Thank you do much for sharing.

[YouExcelTutorials]

Another awesome video! Thanks for sharing Wyn👍

[JonathanExcels]

Thank you. I just need to remember to do it inside of PQ

[warrennalty]

Type the beginning of the formula without the period, then select from the suggested formula list.

[DavidMend]

Wow, didn't know about this before now. Thanks

[pranipradani]

Thank you. This is really helping me 🙏

[khurramliaquat]

Hi, I have a question. When you type a formula in the formula bar, a list of formulas opens. Is this an option that needs to be checked or is there another way to do it?

[maulanaakbari]

My intellisense my excel 2019 OHS not working, how to intellisense working?

[sukoi]

It was indeed a great hack. Thanks a lot.

[sungguhsetianto]

In the second method, in my excel no help appears. How to bring up help like the second method?thanks.

[pascaljoly]

Do you provide a full course on power query?

[IvanCortinas_ES]

Excellent. The method with #shared is the one I usually use. Thank you for this tutorial.