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

  • @DataDisciple
    @DataDisciple7 күн бұрын

    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.

  • @joyetapal5406
    @joyetapal540611 күн бұрын

    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.

  • @PacketElf
    @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.

  • @cherianiype
    @cherianiype2 жыл бұрын

    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!

  • @kennethpaige7036
    @kennethpaige7036 Жыл бұрын

    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!

  • @sebfromgermany3819
    @sebfromgermany38192 жыл бұрын

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

  • @user-bk8db7ud6k
    @user-bk8db7ud6k Жыл бұрын

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

  • @zahoorsarbandi2982
    @zahoorsarbandi29822 жыл бұрын

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

  • @cjimmer4877
    @cjimmer48772 жыл бұрын

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

  • @GoodlyChandeep

    @GoodlyChandeep

    2 жыл бұрын

    Glad you like it!

  • @mimiklimberg1257
    @mimiklimberg1257 Жыл бұрын

    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

    @GoodlyChandeep

    Жыл бұрын

    Thank you for you nice words!

  • @selim.vidangos
    @selim.vidangos10 ай бұрын

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

  • @abhishek12865a
    @abhishek12865a Жыл бұрын

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

  • @HilaryGo555
    @HilaryGo5558 ай бұрын

    Yet another brilliant video. Thank you so much!

  • @ehsanjafari1035
    @ehsanjafari10355 ай бұрын

    Thank you for your effective teaching.👌🏻

  • @adnanabbasi9482
    @adnanabbasi9482 Жыл бұрын

    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 💯

  • @sandeepkhawas3367
    @sandeepkhawas33675 ай бұрын

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

  • @johnfunet
    @johnfunet Жыл бұрын

    Very informative and well explained video, it makes one interested in the subject and look for more similar examples on the subject.

  • @anillpatel
    @anillpatel29 күн бұрын

    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.

  • @naveen.ft21
    @naveen.ft2111 ай бұрын

    Excellent.. Excellent... No words!!!

  • @iankr
    @iankr5 ай бұрын

    Many thanks, Chandeep!

  • @joshuaduplaa9033
    @joshuaduplaa90335 ай бұрын

    You are so helpful! thank you!

  • @skimpylemon8034
    @skimpylemon8034 Жыл бұрын

    Fantastic introduction to understanding M language logic! Thanks a million!!!

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Glad you like it!

  • @user-tl5lw7rc3m
    @user-tl5lw7rc3m2 жыл бұрын

    A simple, rich and easy explanation thanks for all the valuable lessons you offer us

  • @GoodlyChandeep

    @GoodlyChandeep

    2 жыл бұрын

    Glad you like the lessons!

  • @pkuchnicki
    @pkuchnicki Жыл бұрын

    A clear and wonderful explanation of M coding in the right and simple context.

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Thank you!

  • @elizabethl-py7km
    @elizabethl-py7km Жыл бұрын

    Thanks a million, yet to begin, with less fear:)

  • @sucharesh
    @sucharesh4 ай бұрын

    Awesome Query explanation..

  • @KuldeepSingh-nq1vi
    @KuldeepSingh-nq1vi2 жыл бұрын

    Hi Chandeep, you are doing amazing job, pls make a video on "each" and "_" statement as well.

  • @mahmoudkousa766
    @mahmoudkousa766 Жыл бұрын

    Very helpful thanks a lot God bless you ❤

  • @hanszaandam914
    @hanszaandam9145 ай бұрын

    Clear and precise. Thank you.

  • @sircorn4248
    @sircorn4248 Жыл бұрын

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

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Glad it was worth! 💚

  • @faruksedef
    @faruksedef8 ай бұрын

    Great video my friend; cheers from Turkey

  • @rickyzeng5907
    @rickyzeng5907 Жыл бұрын

    Fantastic video. Very instrumental. Thank you!

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Glad you like it!

  • @punchbuddies220
    @punchbuddies220 Жыл бұрын

    You are the best, man! Cheers

  • @BenDieselBasicAutomotive
    @BenDieselBasicAutomotive Жыл бұрын

    Very effective introduction to Power Query. Thank you very much again, Professor...

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Glad you like this Ben!

  • @IQBooksPUBIQBooksPUB
    @IQBooksPUBIQBooksPUB11 ай бұрын

    very good video. talent for teaching!

  • @user-zm8bj1ts9x
    @user-zm8bj1ts9x8 ай бұрын

    Double thumbs up my man. Thanks

  • @AlejandroAlmendro
    @AlejandroAlmendroАй бұрын

    thank you, that was fantastic!

  • @cakirankale
    @cakirankale Жыл бұрын

    This was beautiful for beginner!! So Grateful.

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    So glad Kiran!

  • @larissagorbatova6421
    @larissagorbatova642127 күн бұрын

    Very usefull, thank you a lot!

  • @vijayachandrabagaraoalleni2282
    @vijayachandrabagaraoalleni2282 Жыл бұрын

    Best ever educational video

  • @ram-it.damn-it
    @ram-it.damn-it2 жыл бұрын

    Good stuff. Helpful! Thanks for creating this content.

  • @GoodlyChandeep

    @GoodlyChandeep

    2 жыл бұрын

    Glad it was Helpful!

  • @gauravjagetiya6700
    @gauravjagetiya6700 Жыл бұрын

    from this vedio onwards, i have become fan of you

  • @houstonsam6163
    @houstonsam6163 Жыл бұрын

    Many thanks for a clear explanation of these fundamentals.

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Glad you like them!

  • @ivandariosuarezrodriguez4627
    @ivandariosuarezrodriguez4627 Жыл бұрын

    Thank you very much, an excellent and clear explanation to start in the world of M language

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Glad you liked it

  • @solarson_studio
    @solarson_studio2 жыл бұрын

    thanks for sharing your leaning insights - very intuitive! ! !

  • @GoodlyChandeep

    @GoodlyChandeep

    2 жыл бұрын

    Glad you like it!

  • @eduardomunoz2764
    @eduardomunoz27647 ай бұрын

    Amazing!.. Thank you...

  • @shinaken
    @shinaken2 жыл бұрын

    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

    @kundanbhardwaz6363

    8 ай бұрын

    I also want to learn

  • @krishanphophalia9303
    @krishanphophalia9303 Жыл бұрын

    Awesome 😎 #Chandeep! You are doing amazing stuff! Wishing you good luck and thanks for efforts! ❤

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Glad you like them!

  • @dannypuype6104
    @dannypuype61042 жыл бұрын

    Thanks for sharing your clarity !

  • @GoodlyChandeep

    @GoodlyChandeep

    2 жыл бұрын

    Glad you like it!

  • @advrohitowhal9794
    @advrohitowhal97942 жыл бұрын

    It's really helpful. BIG THANKS!

  • @GoodlyChandeep

    @GoodlyChandeep

    2 жыл бұрын

    Glad it was helpful!

  • @juliane1mota
    @juliane1mota Жыл бұрын

    Dude, you are so good! I love your explanations!

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Glad you like them!

  • @wildecorrea6477
    @wildecorrea64772 жыл бұрын

    🇧🇷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

    @GoodlyChandeep

    2 жыл бұрын

    Glad you like it!

  • @sujit3375

    @sujit3375

    Жыл бұрын

    Link

  • @Nura853
    @Nura853 Жыл бұрын

    Thank you! A very clear explanation!

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Glad you like this Nura!

  • @marceloenlaoficina2236
    @marceloenlaoficina22367 ай бұрын

    Excelent !! Thank you

  • @khalidrasheed7724
    @khalidrasheed7724 Жыл бұрын

    Brillant work. You are a good teacher with knowledge.

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Many thanks!

  • @InformationWoWiase
    @InformationWoWiase Жыл бұрын

    Amazing! I'm at ease now with the M Language!

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Thanks!

  • @cristian.angyal
    @cristian.angyal2 жыл бұрын

    Great intro to M! Really good explanations and a MUST WATCH video for PQ learners! Thanks for sharing Chandeep!

  • @irfanmansoori3060
    @irfanmansoori3060 Жыл бұрын

    Hi buddy.. u r simply superb.. awesome knowledge with amazing teaching skills.. hats off to u..

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Thanks a ton!

  • @mohanbabu9939
    @mohanbabu99392 жыл бұрын

    Good work, thanks for the videos!! really will be helpful

  • @GoodlyChandeep

    @GoodlyChandeep

    2 жыл бұрын

    Glad you like it!

  • @freetrainingvideos
    @freetrainingvideos10 ай бұрын

    Very well explained

  • @benndii
    @benndii Жыл бұрын

    I can see clearly now! Thank you.

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Thanks Dirk, appreciate the tip :)

  • @sukritiguin5637
    @sukritiguin563711 ай бұрын

    Truly Awesome

  • @tariqhussain1497
    @tariqhussain14973 ай бұрын

    Good morning, i was looking for M Language code and good i find this and learn things in that

  • @Uriakus
    @Uriakus Жыл бұрын

    Thank you so much!

  • @user-lm5wb8vi1x
    @user-lm5wb8vi1x4 ай бұрын

    Finished watching

  • @axelgrind
    @axelgrind9 ай бұрын

    Great content!

  • @martyc5674
    @martyc56742 жыл бұрын

    Hey Chandeep- this is Gold for anyone learning M.

  • @GoodlyChandeep

    @GoodlyChandeep

    2 жыл бұрын

    Thank you Martin!

  • @ajieapen
    @ajieapen2 жыл бұрын

    Ah... was waiting for this... Thanks, Chandeep..!!

  • @GoodlyChandeep

    @GoodlyChandeep

    2 жыл бұрын

    Great Aji !

  • @Shubham-xy6xh
    @Shubham-xy6xh4 ай бұрын

    Amazing sir

  • @abdullah_alhathloul_
    @abdullah_alhathloul_ Жыл бұрын

    Great, simple and easy explanation

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Thank you!

  • @KulturanCov
    @KulturanCov Жыл бұрын

    Amazingly succinct! Thanks

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Glad you like it!

  • @manishankarmadishetty7548
    @manishankarmadishetty75483 ай бұрын

    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.

  • @IanDangerfield
    @IanDangerfield Жыл бұрын

    Extremely helpful thank you!

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Glad it was helpful Ian!

  • @aan224
    @aan224 Жыл бұрын

    Awesome work, thanks alot !

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Glad you liked it Anita!

  • @ArmandoReportes
    @ArmandoReportes Жыл бұрын

    Great video! Thanks.

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Glad you like it!

  • @Oilhead710
    @Oilhead7108 күн бұрын

    Great Video

  • @ohdjrp4
    @ohdjrp4 Жыл бұрын

    Thanks so much for this!

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    💚

  • @mattschoular8844
    @mattschoular8844 Жыл бұрын

    Thanks Chandeep. That was really helpful.

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Glad to hear that

  • @gennarocimmino
    @gennarocimmino Жыл бұрын

    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

    @GoodlyChandeep

    Жыл бұрын

    My pleasure 😊

  • @02owel
    @02owel Жыл бұрын

    thanks, very clear explanation

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Glad you liked it Oscar!

  • @munawarhussain6816
    @munawarhussain6816 Жыл бұрын

    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.

  • @girishghadge8460
    @girishghadge8460 Жыл бұрын

    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?

  • @shashipaul6279
    @shashipaul62792 жыл бұрын

    That's phenomenal ...... 👍

  • @GoodlyChandeep

    @GoodlyChandeep

    2 жыл бұрын

    Thank you!

  • @abdullah_dogan
    @abdullah_dogan Жыл бұрын

    Great explanation, thanks

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Glad you liked it

  • @vigneshkumar8720
    @vigneshkumar87202 жыл бұрын

    I was waiting for this one 🙌

  • @GoodlyChandeep

    @GoodlyChandeep

    2 жыл бұрын

    Glad your wait is over 💚

  • @behzadghah
    @behzadghah10 ай бұрын

    You broke the M language taboo for me. Thank you🙏

  • @GoodlyChandeep

    @GoodlyChandeep

    10 ай бұрын

    Happy to help :)

  • @RonDavidowicz
    @RonDavidowicz2 жыл бұрын

    Nice clear explanation!

  • @GoodlyChandeep

    @GoodlyChandeep

    2 жыл бұрын

    Thank you!

  • @Rice0987
    @Rice09872 жыл бұрын

    May i see a video with transformations of nested tables inside of a table column and further extraction of them? :)

  • @hiteshagarwal8242
    @hiteshagarwal8242 Жыл бұрын

    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?

  • @shamf6624
    @shamf66242 жыл бұрын

    This is amazing. Thank you

  • @GoodlyChandeep

    @GoodlyChandeep

    2 жыл бұрын

    Glad you like it! 💚

  • @ershelin
    @ershelin4 ай бұрын

    Thanks for the video. Advance editor intellisense not working. please advice

  • @FRANKWHITE1996
    @FRANKWHITE1996 Жыл бұрын

    pure gold! thanks!

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Glad you like it!

  • @FRANKWHITE1996

    @FRANKWHITE1996

    Жыл бұрын

    @@GoodlyChandeep no doubt! 👍

  • @Seftehandle
    @Seftehandle Жыл бұрын

    is there any simpler video. this is great 👍 i just need it more simple

  • @user-lm5wb8vi1x
    @user-lm5wb8vi1x3 ай бұрын

    finished watching

  • @kiran521
    @kiran521 Жыл бұрын

    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

  • @annaperepechko537
    @annaperepechko537 Жыл бұрын

    Thank you!

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    💚

  • @garylhaas2005
    @garylhaas20052 жыл бұрын

    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.

  • @MrKamranhaider0
    @MrKamranhaider02 жыл бұрын

    Just amazing

  • @GoodlyChandeep

    @GoodlyChandeep

    Жыл бұрын

    Thank you!

  • @sujit3375
    @sujit3375 Жыл бұрын

    Complete course needed

  • @Rice0987
    @Rice09872 жыл бұрын

    Advance editor is always available on Home tab under Properties button. :)

Келесі