Getting Started With M Language in Power Query | Basic to Advanced

In this video, I'll share some guidelines to help you get your journey started with M Language in Power Query. Enjoy!

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

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

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

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

===== CHAPTERS =====
0:00 Intro
0:24 Table of Contents
1:05 Part 1 - Exploring Syntax of M Language
1:06 Learning 1 - Every Step is a Variable
3:07 Learning 2 - Comma at the end of each step but not the last one
3:45 Learning 3 - Use let and in to define steps
4:53 Learning 4 - Steps don't need to be in coherent order
5:57 Learning 5 - Query gets evaluated bottom up
7:21 Part 2 - Creating a Simple Query
11:02 Part 3 - Introduction to Object Structure
11:39 Lists
15:02 Records
18:37 Scalar Values
21:07 Functions
24:33 My Courses

===== 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!

- - - - -
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
Official After The Fall YouTube Channel Below
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)

[joyetapal]

So far this is one of the best introductory video on M Language. The overview is simple, apt and easy to grasp along with the simplest examples possible. It will be a great help in my Power Query journey. Thanks Chandeep for all your efforts.

[mimiklimberg]

Amazing! Goodly - You are the best. This particular video is like none other as it focuses on the fundamentals, the underpinnings. You don't dumb it down. You give the average user access to the more powerful aspects of Power Query.

[DataDisciple]

Thank you - I am working as a Data Analyst, and quite often I use Power Query to help clear up poorly input data from multiple files. It's great to have had an overview like this. Should be a good tool on the belt alongside PowerBI, Dax and SQL.

[cjimmer]

I haven't seen any other YouTube's do this kind of content before. thank you!

[PacketElf]

Great overview! Thanks so much. Really helped give me the overview I needed to start digging into M. You’ve got great skill at teaching and breaking concepts down into logical pieces.

[sircorn]

Oh, man. This 25 min video has given me more knowledge than a dozen I watched before. Many thanks and my subscription.

[kennethpaige]

Even after two or three other introductory PQ courses, I still managed to learn something new, and walk away with a better overall understanding of Power Query. Thank you!

[cherianiype]

this video Goodly is truly awesome man! You've very clearly explained the foundations of PQ's advanced editor - you've helped your viewers digest the elements of the language. Bahut Shukriya, Shukran Jazeelan, Thank you very much! Keep doing this man! Best wishes! Big fan! well done!

[shinaken]

Just started learning M a week ago and I'm already creating the keys that I need to make my PowerBI run 20x faster. Thank you!

[bkdbudk]

This video is amazing for someone like me who rarely opens the advanced editor. Now I totally understand what is happening!!!

[anillpatel]

This is a great video for anyone who wants to get an understanding of the M language.
You should watch this presentation first before diving into Power Query. It will make a lot more sense then.
Thanks Chandeep.

[adnanabbasi]

You make me compulsive to acknowledge that though the video is simple, short, and concise.
But, this video is the basic building block "foundation" for learning PowerQuery M-Language. 💯out of 💯

[zahoorsarbandi]

Really the best start for PQ learners... Very good information and explanation.. A PQ learner MUST watch this video

[abhisheka]

bhai guruji ki bahut kripa hai aapke upar keep it up you are an excellent phenomenal tutor

[sebfromgermany]

Who needs textbooks if you have Chandeep’s tutorials! Cheers mate for this one - it’s excellent 👍

[mytciopinfo]

Excellent video!! Thank you for the great instruction and clear teaching style.

[yuhooh]

The 25 minutes spending to watch this is very valuable, thanks you

[selim.vidangos]

This video is awesome, it has accurate information that I needed to understand M language for Power Query, thanks man!

[manishankarmadishetty]

Very Good Explanation!!! Doubt: How do we get existing column names as suggestions while writing the advanced editor. As I observed, the suggestions are coming when we write in a add new column window. Thanks in advance.

[sandeepkhawas]

Amazing ! you are the best teacher pls keep uploading videos on M code!