Getting Started With M Language in Power Query | Basic to Advanced
ฝัง
- เผยแพร่เมื่อ 13 มิ.ย. 2024
- 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 TH-cam Channel Below
th-cam.com/channels/GQE.html...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: creativecommons.org/licenses - วิทยาศาสตร์และเทคโนโลยี
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.
Thank you for you nice words!
I haven't seen any other TH-cam's do this kind of content before. thank you!
Glad you like it!
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.
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.
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!
Really the best start for PQ learners... Very good information and explanation.. A PQ learner MUST watch this video
This video is amazing for someone like me who rarely opens the advanced editor. Now I totally understand what is happening!!!
bhai guruji ki bahut kripa hai aapke upar keep it up you are an excellent phenomenal tutor
Oh, man. This 25 min video has given me more knowledge than a dozen I watched before. Many thanks and my subscription.
Glad it was worth! 💚
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!
Who needs textbooks if you have Chandeep’s tutorials! Cheers mate for this one - it’s excellent 👍
Thank you for your effective teaching.👌🏻
Yet another brilliant video. Thank you so much!
Excellent.. Excellent... No words!!!
This video is awesome, it has accurate information that I needed to understand M language for Power Query, thanks man!
You are so helpful! thank you!
Many thanks, Chandeep!
Clear and precise. Thank you.
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!
Fantastic introduction to understanding M language logic! Thanks a million!!!
Glad you like it!
thank you, that was fantastic!
A clear and wonderful explanation of M coding in the right and simple context.
Thank you!
Very informative and well explained video, it makes one interested in the subject and look for more similar examples on the subject.
Very helpful thanks a lot God bless you ❤
Fantastic video. Very instrumental. Thank you!
Glad you like it!
Awesome Query explanation..
very good video. talent for teaching!
Very usefull, thank you a lot!
I can see clearly now! Thank you.
Thanks Dirk, appreciate the tip :)
A simple, rich and easy explanation thanks for all the valuable lessons you offer us
Glad you like the lessons!
Thanks a million, yet to begin, with less fear:)
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!
I also want to learn
This was beautiful for beginner!! So Grateful.
So glad Kiran!
Best ever educational video
Thank you! A very clear explanation!
Glad you like this Nura!
Amazing!.. Thank you...
Excelent !! Thank you
Great video my friend; cheers from Turkey
Thanks for sharing your clarity !
Glad you like it!
Thank you so much!
thanks for sharing your leaning insights - very intuitive! ! !
Glad you like it!
Many thanks for a clear explanation of these fundamentals.
Glad you like them!
It's really helpful. BIG THANKS!
Glad it was helpful!
Very effective introduction to Power Query. Thank you very much again, Professor...
Glad you like this Ben!
You are the best, man! Cheers
thanks, very clear explanation
Glad you liked it Oscar!
Extremely helpful thank you!
Glad it was helpful Ian!
Brillant work. You are a good teacher with knowledge.
Many thanks!
Awesome work, thanks alot !
Glad you liked it Anita!
Thanks so much for this!
💚
Amazing! I'm at ease now with the M Language!
Thanks!
Double thumbs up my man. Thanks
Amazing sir
Great explanation, thanks
Glad you liked it
Great, simple and easy explanation
Thank you!
Amazingly succinct! Thanks
Glad you like it!
Thank you very much, an excellent and clear explanation to start in the world of M language
Glad you liked it
Good stuff. Helpful! Thanks for creating this content.
Glad it was Helpful!
Thanks Chandeep. That was really helpful.
Glad to hear that
Truly Awesome
Great content!
from this vedio onwards, i have become fan of you
Great video! Thanks.
Glad you like it!
Very well explained
🇧🇷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!!! 👏🏻👏🏻👏🏻✅🔝👏🏻👏🏻👏🏻
Glad you like it!
Link
pure gold! thanks!
Glad you like it!
@@GoodlyChandeep no doubt! 👍
Good work, thanks for the videos!! really will be helpful
Glad you like it!
Dude, you are so good! I love your explanations!
Glad you like them!
Finished watching
Awesome 😎 #Chandeep! You are doing amazing stuff! Wishing you good luck and thanks for efforts! ❤
Glad you like them!
That's phenomenal ...... 👍
Thank you!
Hi Chandeep, you are doing amazing job, pls make a video on "each" and "_" statement as well.
Hey Chandeep- this is Gold for anyone learning M.
Thank you Martin!
Hi buddy.. u r simply superb.. awesome knowledge with amazing teaching skills.. hats off to u..
Thanks a ton!
Just amazing
Thank you!
Nice clear explanation!
Thank you!
Thank you!
💚
This is amazing. Thank you
Glad you like it! 💚
Awesome video¡
Thanks Hugo!
Phenomenal
Thanks!
Ah... was waiting for this... Thanks, Chandeep..!!
Great Aji !
You broke the M language taboo for me. Thank you🙏
Happy to help :)
Really Amazing..
Thank you!
I was waiting for this one 🙌
Glad your wait is over 💚
Amazing episode ☺️
Thank you!
finished watching
Great intro to M! Really good explanations and a MUST WATCH video for PQ learners!
Thanks for sharing Chandeep!
Good morning, i was looking for M Language code and good i find this and learn things in that
very good
Thank you!
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.
Nice explained
Thank you!
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?
Complete course needed
Thanks for the video. Advance editor intellisense not working. please advice
May i see a video with transformations of nested tables inside of a table column and further extraction of them? :)
Thanks
💚
Great explanation I watched full video with being a bored for 1 second
Thank you! Glad you like it!
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.
My pleasure 😊
is there any simpler video. this is great 👍 i just need it more simple