Don't Type the Dot! | How to Get Power Query Intellisense To Work #shorts

For the longest time, entering M-Functions in Microsoft Power Query was a frustrating exercise for me. Until I discovered the trick I'm sharing in this video.

🚩Let’s connect on social:

👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel #powerquery

[JaredWinward]

This has driven me crazy for YEARS. Thank you!!

[susanymendonca]

Wow This used to drive me crazy! Thank you for this tip!!

[raimundojs]

Great tip! Thanks for sharing. We could also type just the initials, like... tcn for Table.ColumnNames or rtt for Record.ToTable, for instance, or choose a similar from the dropdown list brought by the intellisense.

[rwfrenchGenX]

Thank you for all these frustration savers! I sincerely enjoy the other time saving educational videos you share but for me helping to reduce the workarounds and frustrations are really raising the quality of my day. Your other videos saves me time, improves my effectiveness and allows me to keep getting a paycheck and I’m grateful for that, but it works out for the company I work for more than it benefits me because I share your knowledge with people and now the company is getting a few extra weeks of productivity from us that is more accurate and looks more professional and is often automated saving a lot of labor. There’s always something I can learn but 95% of my work flow is set up as good as it will get. Anything I can learn to improve the quality of my day is valued on same level as my job security. Thanks and Happy Holidays!

[RaymondLeslie]

Amazing Productivity Tip! These small simple improvements really add up!!!

Thanks! -Ray L

[morze]

Amazing! I had same issue. I tought it is a bug. Thank you for clarifing.

[netpilot]

Such a short, concise, yet profoundly useful short! Perfect!

[mcwahaab]

I was struggling the same earlier today. Thanks a million.

[andersthechamp]

Wow. How have I never looked this up! This has been annoying me for so long but I just accepted it and thought that this was so stupid. Thank you!

[CassidyHood]

Oh my word, this has been driving me crazy. You have saved me so much work in the future.

[mathteacher]

Oh my goodness, thank you! I also thought this was an annoying bug. 🙏

[navisalomi]

I have always used this. Just stumbled it one day. It was magical.

[excelsocallmaster]

Didn’t know that..excellent that was one of my biggest frustrations with power query

[danielascibilia]

OMG! Thank you so much! This thing was so annoying!

[RAHowarth]

How do you record your screen, cropped for mobile, so cleanly like this? 🙏

[Skyfiah]

This has annoyed me for so long 😅 Thanks!

[dirtydan]

Hi Leila do you have a video on filtering QuickBooks ledgers? They’re so messy. I’d like a way to create a 1 column trial balance from it

[kuuuyajim]

Wow! Didn't know it works that way. LoL 😂

[octavianr]

A hint what is doing that function would be good also... i know there is Help, whatever :)

[martincm]

And if you press enter instead of tab ?