Getting Started with the Power Query Advanced Editor & M CODE for Beginners

Learn and understand the Power Query Advanced Editor which shows the behind the scenes code that Power Query is creating with each step by step transformation. Knowing these basics will help up your Power Query skills and introduce you to M Code, which is Power Query's formula language.

✅ Please see link to video mentioned in this video:

⏲️Video Timestamps:
00:00 What is the Power Query Advanced Editor and Understanding M Code
06:03 What do the Different Types of Brackets Do in Power Query?
11:15 How to Access the Full List of Power Query Functions

✅ If you would like to buy me a coffee, so I can get my caffeine in to keep creating as many videos as possible for you :). It's really quick and easy, please use this link:

✅ For more videos please subscribe:

✅ For more Power Query videos please use the links below:

[anillpatel]

Excellent video presentation.
Watch this video first to get a good understanding of the way Power Query works and the syntax for M Code.
Thanks Melissa.

[malchicken]

Thank you for explaining the possible versions of blue text vs. green text. A video focused on each of those key terms would be much appreciated. Thank you 🙏🏽.

[heishoi]

thank you, this is great video on M Code for beginner 👍👍👍

[nuqwestr]

I use Udemy but your videos surpass all available there, as most instructors feel the need to inject "overt" personality and extraneous comments in their videos. I've learned more from you in 20-minutes than others I've watched for hours. I sent you a coffee, and will again. Miss Microsoft, you are a star.

[kailash]

Very helpful. This information I missed in my Power Query course. Thank you.

[dcpowered]

I am new to Power Query and this video is very helpful! Thanks a lot! Could you please explain how to use code shared by others as copied from their advanced editor?

[neerajkaushik]

I appreciate your effort....i will highly recommend everyone to subscribe your channel

[JJ_TheGreat]

9:38 I find it interesting that to pull a column from a table, you use square brackets “[]” and it returns a list… Whereas, using the same type of brackets (square: “[]”) without indicating the table name actually returns/creates a record (NOT a LIST). To create a list, you have to enter the curly brackets - what I called “braces” - “{}”. This seems counter-intuitive to me!

[laarum]

how can i save query settings for later use ?

[saratoffice]

In power query if a step is wrongly deleted then how can we undo it ?

[thebhaskarjoshi]

Is there any full form of "M Language"?