Getting Started With M Language in Power Query | Basic to Advanced
HTML-код
- Опубликовано: 23 июл 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 RUclips Channel Below
ruclips.net/channel/UCGQE...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: creativecommons.org/licenses - Наука
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.
The 25 minutes spending to watch this is very valuable, thanks you
I haven't seen any other RUclips's do this kind of content before. thank you!
Glad you like it!
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 👍
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!
Excellent video!! Thank you for the great instruction and clear teaching style.
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
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!
This video is awesome, it has accurate information that I needed to understand M language for Power Query, thanks man!
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 💯
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! 💚
Thank you for your effective teaching.👌🏻
You are so helpful! thank you!
Excellent.. Excellent... No words!!!
Very informative and well explained video, it makes one interested in the subject and look for more similar examples on the subject.
Amazing ! you are the best teacher pls keep uploading videos on M code!
A simple, rich and easy explanation thanks for all the valuable lessons you offer us
Glad you like the lessons!
A clear and wonderful explanation of M coding in the right and simple context.
Thank you!
Many thanks, Chandeep!
Fantastic introduction to understanding M language logic! Thanks a million!!!
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.
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
thank you, that was fantastic!
Thanks a million, yet to begin, with less fear:)
Clear and precise. Thank you.
You are the best, man! Cheers
Very usefull, thank you a lot!
Fantastic video. Very instrumental. Thank you!
Glad you like it!
Very helpful thanks a lot God bless you ❤
This was beautiful for beginner!! So Grateful.
So glad Kiran!
very good video. talent for teaching!
Awesome Query explanation..
Many thanks for a clear explanation of these fundamentals.
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!!! 👏🏻👏🏻👏🏻✅🔝👏🏻👏🏻👏🏻
Glad you like it!
Link
Amazing!.. Thank you...
Double thumbs up my man. Thanks
Excelent !! Thank you
Dude, you are so good! I love your explanations!
Glad you like them!
Amazing! I'm at ease now with the M Language!
Thanks!
Good stuff. Helpful! Thanks for creating this content.
Glad it was Helpful!
Thank you very much, an excellent and clear explanation to start in the world of M language
Glad you liked it
Thanks for sharing your clarity !
Glad you like it!
thanks for sharing your leaning insights - very intuitive! ! !
Glad you like it!
Hi Chandeep, you are doing amazing job, pls make a video on "each" and "_" statement as well.
Best ever educational video
Thank you! A very clear explanation!
Glad you like this Nura!
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!
Good work, thanks for the videos!! really will be helpful
Glad you like it!
Awesome work, thanks alot !
Glad you liked it Anita!
Great video my friend; cheers from Turkey
I can see clearly now! Thank you.
Thanks Dirk, appreciate the tip :)
Amazingly succinct! Thanks
Glad you like it!
Extremely helpful thank you!
Glad it was helpful Ian!
Brillant work. You are a good teacher with knowledge.
Many thanks!
Great video! Thanks.
Glad you like it!
Thanks so much for this!
💚
Hey Chandeep- this is Gold for anyone learning M.
Thank you Martin!
Truly Awesome
pure gold! thanks!
Glad you like it!
@@GoodlyChandeep no doubt! 👍
Great content!
Thank you so much!
Awesome 😎 #Chandeep! You are doing amazing stuff! Wishing you good luck and thanks for efforts! ❤
Glad you like them!
Great Video
Finished watching
Amazing sir
Thanks Chandeep. That was really helpful.
Glad to hear that
from this vedio onwards, i have become fan of you
Ah... was waiting for this... Thanks, Chandeep..!!
Great Aji !
Great, simple and easy explanation
Thank you!
Great explanation, thanks
Glad you liked it
thanks, very clear explanation
Glad you liked it Oscar!
Hi buddy.. u r simply superb.. awesome knowledge with amazing teaching skills.. hats off to u..
Thanks a ton!
Very well explained
This is amazing. Thank you
Glad you like it! 💚
I was waiting for this one 🙌
Glad your wait is over 💚
You broke the M language taboo for me. Thank you🙏
Happy to help :)
That's phenomenal ...... 👍
Thank you!
Nice clear explanation!
Thank you!
Just amazing
Thank you!
Good morning, i was looking for M Language code and good i find this and learn things in that
Thank you!
💚
Phenomenal
Thanks!
Awesome video¡
Thanks Hugo!
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 😊
Great intro to M! Really good explanations and a MUST WATCH video for PQ learners!
Thanks for sharing Chandeep!
Really Amazing..
Thank you!
finished watching
Amazing episode ☺️
Thank you!
is there any simpler video. this is great 👍 i just need it more simple
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.
very good
Thank you!
Complete course needed
Great explanation I watched full video with being a bored for 1 second
Thank you! Glad you like it!