Getting Started With M Language in Power Query | Basic to Advanced
Ғылым және технология
Check out our newly launched M Language course ↗️ - goodly.co.in/learn-m-powerquery/
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 -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== 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
- Source: goo.gl/fh3rEJ
Official After The Fall KZread Channel Below
kzread.info/dron/GQE.html...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: creativecommons.org/licenses
Пікірлер: 204
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.
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.
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.
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!
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!
Who needs textbooks if you have Chandeep’s tutorials! Cheers mate for this one - it’s excellent 👍
This video is amazing for someone like me who rarely opens the advanced editor. Now I totally understand what is happening!!!
Really the best start for PQ learners... Very good information and explanation.. A PQ learner MUST watch this video
I haven't seen any other KZread's do this kind of content before. thank you!
@GoodlyChandeep
2 жыл бұрын
Glad you like it!
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.
@GoodlyChandeep
Жыл бұрын
Thank you for you nice words!
This video is awesome, it has accurate information that I needed to understand M language for Power Query, thanks man!
bhai guruji ki bahut kripa hai aapke upar keep it up you are an excellent phenomenal tutor
Yet another brilliant video. Thank you so much!
Thank you for your effective teaching.👌🏻
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 💯
Amazing ! you are the best teacher pls keep uploading videos on M code!
Very informative and well explained video, it makes one interested in the subject and look for more similar examples on the subject.
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.
Excellent.. Excellent... No words!!!
Many thanks, Chandeep!
You are so helpful! thank you!
Fantastic introduction to understanding M language logic! Thanks a million!!!
@GoodlyChandeep
Жыл бұрын
Glad you like it!
A simple, rich and easy explanation thanks for all the valuable lessons you offer us
@GoodlyChandeep
2 жыл бұрын
Glad you like the lessons!
A clear and wonderful explanation of M coding in the right and simple context.
@GoodlyChandeep
Жыл бұрын
Thank you!
Thanks a million, yet to begin, with less fear:)
Awesome Query explanation..
Hi Chandeep, you are doing amazing job, pls make a video on "each" and "_" statement as well.
Very helpful thanks a lot God bless you ❤
Clear and precise. Thank you.
Oh, man. This 25 min video has given me more knowledge than a dozen I watched before. Many thanks and my subscription.
@GoodlyChandeep
Жыл бұрын
Glad it was worth! 💚
Great video my friend; cheers from Turkey
Fantastic video. Very instrumental. Thank you!
@GoodlyChandeep
Жыл бұрын
Glad you like it!
You are the best, man! Cheers
Very effective introduction to Power Query. Thank you very much again, Professor...
@GoodlyChandeep
Жыл бұрын
Glad you like this Ben!
very good video. talent for teaching!
Double thumbs up my man. Thanks
thank you, that was fantastic!
This was beautiful for beginner!! So Grateful.
@GoodlyChandeep
Жыл бұрын
So glad Kiran!
Very usefull, thank you a lot!
Best ever educational video
Good stuff. Helpful! Thanks for creating this content.
@GoodlyChandeep
2 жыл бұрын
Glad it was Helpful!
from this vedio onwards, i have become fan of you
Many thanks for a clear explanation of these fundamentals.
@GoodlyChandeep
Жыл бұрын
Glad you like them!
Thank you very much, an excellent and clear explanation to start in the world of M language
@GoodlyChandeep
Жыл бұрын
Glad you liked it
thanks for sharing your leaning insights - very intuitive! ! !
@GoodlyChandeep
2 жыл бұрын
Glad you like it!
Amazing!.. Thank you...
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!
@kundanbhardwaz6363
8 ай бұрын
I also want to learn
Awesome 😎 #Chandeep! You are doing amazing stuff! Wishing you good luck and thanks for efforts! ❤
@GoodlyChandeep
Жыл бұрын
Glad you like them!
Thanks for sharing your clarity !
@GoodlyChandeep
2 жыл бұрын
Glad you like it!
It's really helpful. BIG THANKS!
@GoodlyChandeep
2 жыл бұрын
Glad it was helpful!
Dude, you are so good! I love your explanations!
@GoodlyChandeep
Жыл бұрын
Glad you like them!
🇧🇷Wow!!! What an excellent beginner's guide class!!! Awesome!!! 🔝🔝🔝 Congratulations!!! Thank you!!! 👏🏻👏🏻👏🏻 I've seen one of your videos about M Code for transformation function. You've shown us a general formula with double curly brackets as arguments of a transformation formula!!! Excellent!!! 👏🏻👏🏻👏🏻✅🔝👏🏻👏🏻👏🏻
@GoodlyChandeep
2 жыл бұрын
Glad you like it!
@sujit3375
Жыл бұрын
Link
Thank you! A very clear explanation!
@GoodlyChandeep
Жыл бұрын
Glad you like this Nura!
Excelent !! Thank you
Brillant work. You are a good teacher with knowledge.
@GoodlyChandeep
Жыл бұрын
Many thanks!
Amazing! I'm at ease now with the M Language!
@GoodlyChandeep
Жыл бұрын
Thanks!
Great intro to M! Really good explanations and a MUST WATCH video for PQ learners! Thanks for sharing Chandeep!
Hi buddy.. u r simply superb.. awesome knowledge with amazing teaching skills.. hats off to u..
@GoodlyChandeep
Жыл бұрын
Thanks a ton!
Good work, thanks for the videos!! really will be helpful
@GoodlyChandeep
2 жыл бұрын
Glad you like it!
Very well explained
I can see clearly now! Thank you.
@GoodlyChandeep
Жыл бұрын
Thanks Dirk, appreciate the tip :)
Truly Awesome
Good morning, i was looking for M Language code and good i find this and learn things in that
Thank you so much!
Finished watching
Great content!
Hey Chandeep- this is Gold for anyone learning M.
@GoodlyChandeep
2 жыл бұрын
Thank you Martin!
Ah... was waiting for this... Thanks, Chandeep..!!
@GoodlyChandeep
2 жыл бұрын
Great Aji !
Amazing sir
Great, simple and easy explanation
@GoodlyChandeep
Жыл бұрын
Thank you!
Amazingly succinct! Thanks
@GoodlyChandeep
Жыл бұрын
Glad you like it!
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.
Extremely helpful thank you!
@GoodlyChandeep
Жыл бұрын
Glad it was helpful Ian!
Awesome work, thanks alot !
@GoodlyChandeep
Жыл бұрын
Glad you liked it Anita!
Great video! Thanks.
@GoodlyChandeep
Жыл бұрын
Glad you like it!
Great Video
Thanks so much for this!
@GoodlyChandeep
Жыл бұрын
💚
Thanks Chandeep. That was really helpful.
@GoodlyChandeep
Жыл бұрын
Glad to hear that
Hi Chandeep (not Goodly) .... :) Thank you for this important information which, indeed, is the basics for newbies like me. And especially Kudos! for your ability to "tell" and simplify complicated concepts. See you soon.
@GoodlyChandeep
Жыл бұрын
My pleasure 😊
thanks, very clear explanation
@GoodlyChandeep
Жыл бұрын
Glad you liked it Oscar!
Bro please need your help! I have a situation I have a column "Style Name" where the is a production description like "Jackets for men" or "Men's Jacket" I need the word mens to be in new column. there colud be long description but I only need to extract "Male, Female, KIDS, etc." how can I do that.
Thanks Chandeep for this wonderful video on very basics . May i ask you that your advance editor has intellisence which helps coding very much but i dont ind that in my or default advance editor can you please help in guiding that how can i get the same editor?
That's phenomenal ...... 👍
@GoodlyChandeep
2 жыл бұрын
Thank you!
Great explanation, thanks
@GoodlyChandeep
Жыл бұрын
Glad you liked it
I was waiting for this one 🙌
@GoodlyChandeep
2 жыл бұрын
Glad your wait is over 💚
You broke the M language taboo for me. Thank you🙏
@GoodlyChandeep
10 ай бұрын
Happy to help :)
Nice clear explanation!
@GoodlyChandeep
2 жыл бұрын
Thank you!
May i see a video with transformations of nested tables inside of a table column and further extraction of them? :)
Hi Chandeep, first of all, thanks for this video, It is very helpful. Just wanted to know about where I can find at one place which mentions which type of brackets to be used in which scenario. I know that you discussed some of them in the video, however if there are some other combinations, where I can actually find them?
This is amazing. Thank you
@GoodlyChandeep
2 жыл бұрын
Glad you like it! 💚
Thanks for the video. Advance editor intellisense not working. please advice
pure gold! thanks!
@GoodlyChandeep
Жыл бұрын
Glad you like it!
@FRANKWHITE1996
Жыл бұрын
@@GoodlyChandeep no doubt! 👍
is there any simpler video. this is great 👍 i just need it more simple
finished watching
Amazing video, can u please make video on how to write custom query manully (native query) in advance editor to import table from sql server
Thank you!
@GoodlyChandeep
Жыл бұрын
💚
it's easy for an expert to understand the material. the trick is to understand the material, understand the knowledge level of the "student" and explain using words and concepts the "student" can digest. my belly is full.
Just amazing
@GoodlyChandeep
Жыл бұрын
Thank you!
Complete course needed
Advance editor is always available on Home tab under Properties button. :)