Тёмный

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

Goodly
Подписаться 89 тыс.
Просмотров 71 тыс.
50% 1

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 RU-vid Channel Below
ru-vid.com/show-UCGQE...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: creativecommons.org/licenses

Наука

Опубликовано:

 

22 июн 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 202   
@joyetapal5406
@joyetapal5406 59 минут назад
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.
@anillpatel
@anillpatel 17 дней назад
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.
@cjimmer4877
@cjimmer4877 Год назад
I haven't seen any other RU-vid's do this kind of content before. thank you!
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you like it!
@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!
@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!
@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.
@naveen.ft21
@naveen.ft21 11 месяцев назад
Excellent.. Excellent... No words!!!
@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
@zahoorsarbandi2982 Год назад
Really the best start for PQ learners... Very good information and explanation.. A PQ learner MUST watch this video
@sebfromgermany3819
@sebfromgermany3819 Год назад
Who needs textbooks if you have Chandeep’s tutorials! Cheers mate for this one - it’s excellent 👍
@HilaryGo555
@HilaryGo555 8 месяцев назад
Yet another brilliant video. Thank you so much!
@abhishek12865a
@abhishek12865a Год назад
bhai guruji ki bahut kripa hai aapke upar keep it up you are an excellent phenomenal tutor
@hanszaandam914
@hanszaandam914 5 месяцев назад
Clear and precise. Thank you.
@ehsanjafari1035
@ehsanjafari1035 5 месяцев назад
Thank you for your effective teaching.👌🏻
@iankr
@iankr 5 месяцев назад
Many thanks, Chandeep!
@joshuaduplaa9033
@joshuaduplaa9033 5 месяцев назад
You are so helpful! thank you!
@selim.vidangos
@selim.vidangos 9 месяцев назад
This video is awesome, it has accurate information that I needed to understand M language for Power Query, thanks man!
@cherianiype
@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!
@AlejandroAlmendro
@AlejandroAlmendro Месяц назад
thank you, that was fantastic!
@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
@sandeepkhawas3367 5 месяцев назад
Amazing ! you are the best teacher pls keep uploading videos on M code!
@skimpylemon8034
@skimpylemon8034 Год назад
Fantastic introduction to understanding M language logic! Thanks a million!!!
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you like it!
@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
@sucharesh 3 месяца назад
Awesome Query explanation..
@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! 💚
@larissagorbatova6421
@larissagorbatova6421 15 дней назад
Very usefull, thank you a lot!
@user-tl5lw7rc3m
@user-tl5lw7rc3m Год назад
A simple, rich and easy explanation thanks for all the valuable lessons you offer us
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you like the lessons!
@user-zm8bj1ts9x
@user-zm8bj1ts9x 8 месяцев назад
Double thumbs up my man. Thanks
@punchbuddies220
@punchbuddies220 Год назад
You are the best, man! Cheers
@mahmoudkousa766
@mahmoudkousa766 Год назад
Very helpful thanks a lot God bless you ❤
@johnfunet
@johnfunet Год назад
Very informative and well explained video, it makes one interested in the subject and look for more similar examples on the subject.
@eduardomunoz2764
@eduardomunoz2764 7 месяцев назад
Amazing!.. Thank you...
@rickyzeng5907
@rickyzeng5907 Год назад
Fantastic video. Very instrumental. Thank you!
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you like it!
@vijayachandrabagaraoalleni2282
Best ever educational video
@marceloenlaoficina2236
@marceloenlaoficina2236 7 месяцев назад
Excelent !! Thank you
@BenDieselBasicAutomotive
@BenDieselBasicAutomotive Год назад
Very effective introduction to Power Query. Thank you very much again, Professor...
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you like this Ben!
@InformationWoWiase
@InformationWoWiase Год назад
Amazing! I'm at ease now with the M Language!
@GoodlyChandeep
@GoodlyChandeep Год назад
Thanks!
@cakirankale
@cakirankale Год назад
This was beautiful for beginner!! So Grateful.
@GoodlyChandeep
@GoodlyChandeep Год назад
So glad Kiran!
@IQBooksPUBIQBooksPUB
@IQBooksPUBIQBooksPUB 11 месяцев назад
very good video. talent for teaching!
@dannypuype6104
@dannypuype6104 Год назад
Thanks for sharing your clarity !
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you like it!
@houstonsam6163
@houstonsam6163 Год назад
Many thanks for a clear explanation of these fundamentals.
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you like them!
@Uriakus
@Uriakus Год назад
Thank you so much!
@Nura853
@Nura853 Год назад
Thank you! A very clear explanation!
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you like this Nura!
@faruksedef
@faruksedef 7 месяцев назад
Great video my friend; cheers from Turkey
@shinaken
@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!
@kundanbhardwaz6363
@kundanbhardwaz6363 7 месяцев назад
I also want to learn
@advrohitowhal9794
@advrohitowhal9794 Год назад
It's really helpful. BIG THANKS!
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad it was helpful!
@benndii
@benndii Год назад
I can see clearly now! Thank you.
@GoodlyChandeep
@GoodlyChandeep Год назад
Thanks Dirk, appreciate the tip :)
@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_studio Год назад
thanks for sharing your leaning insights - very intuitive! ! !
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you like it!
@sukritiguin5637
@sukritiguin5637 10 месяцев назад
Truly Awesome
@ArmandoReportes
@ArmandoReportes Год назад
Great video! Thanks.
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you like it!
@martyc5674
@martyc5674 Год назад
Hey Chandeep- this is Gold for anyone learning M.
@GoodlyChandeep
@GoodlyChandeep Год назад
Thank you Martin!
@IanDangerfield
@IanDangerfield Год назад
Extremely helpful thank you!
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad it was helpful Ian!
@ram-it.damn-it
@ram-it.damn-it Год назад
Good stuff. Helpful! Thanks for creating this content.
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad it was Helpful!
@aan224
@aan224 Год назад
Awesome work, thanks alot !
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you liked it Anita!
@khalidrasheed7724
@khalidrasheed7724 Год назад
Brillant work. You are a good teacher with knowledge.
@GoodlyChandeep
@GoodlyChandeep Год назад
Many thanks!
@juliane1mota
@juliane1mota Год назад
Dude, you are so good! I love your explanations!
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you like them!
@Shubham-xy6xh
@Shubham-xy6xh 4 месяца назад
Amazing sir
@freetrainingvideos
@freetrainingvideos 10 месяцев назад
Very well explained
@KulturanCov
@KulturanCov Год назад
Amazingly succinct! Thanks
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you like it!
@gauravjagetiya6700
@gauravjagetiya6700 Год назад
from this vedio onwards, i have become fan of you
@ohdjrp4
@ohdjrp4 Год назад
Thanks so much for this!
@GoodlyChandeep
@GoodlyChandeep Год назад
💚
@axelgrind
@axelgrind 9 месяцев назад
Great content!
@mohanbabu9939
@mohanbabu9939 Год назад
Good work, thanks for the videos!! really will be helpful
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you like it!
@02owel
@02owel Год назад
thanks, very clear explanation
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you liked it Oscar!
@KuldeepSingh-nq1vi
@KuldeepSingh-nq1vi Год назад
Hi Chandeep, you are doing amazing job, pls make a video on "each" and "_" statement as well.
@abdullah_alhathloul_
@abdullah_alhathloul_ Год назад
Great, simple and easy explanation
@GoodlyChandeep
@GoodlyChandeep Год назад
Thank you!
@FRANKWHITE1996
@FRANKWHITE1996 Год назад
pure gold! thanks!
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you like it!
@FRANKWHITE1996
@FRANKWHITE1996 Год назад
@@GoodlyChandeep no doubt! 👍
@wildecorrea6477
@wildecorrea6477 Год назад
🇧🇷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 Год назад
Glad you like it!
@sujit3375
@sujit3375 Год назад
Link
@mattschoular8844
@mattschoular8844 Год назад
Thanks Chandeep. That was really helpful.
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad to hear that
@user-lm5wb8vi1x
@user-lm5wb8vi1x 3 месяца назад
Finished watching
@krishanphophalia9303
@krishanphophalia9303 Год назад
Awesome 😎 #Chandeep! You are doing amazing stuff! Wishing you good luck and thanks for efforts! ❤
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you like them!
@irfanmansoori3060
@irfanmansoori3060 Год назад
Hi buddy.. u r simply superb.. awesome knowledge with amazing teaching skills.. hats off to u..
@GoodlyChandeep
@GoodlyChandeep Год назад
Thanks a ton!
@abdullah_dogan
@abdullah_dogan Год назад
Great explanation, thanks
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you liked it
@ajieapen
@ajieapen Год назад
Ah... was waiting for this... Thanks, Chandeep..!!
@GoodlyChandeep
@GoodlyChandeep Год назад
Great Aji !
@behzadghah
@behzadghah 10 месяцев назад
You broke the M language taboo for me. Thank you🙏
@GoodlyChandeep
@GoodlyChandeep 10 месяцев назад
Happy to help :)
@shashipaul6279
@shashipaul6279 Год назад
That's phenomenal ...... 👍
@GoodlyChandeep
@GoodlyChandeep Год назад
Thank you!
@shamf6624
@shamf6624 Год назад
This is amazing. Thank you
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad you like it! 💚
@RonDavidowicz
@RonDavidowicz Год назад
Nice clear explanation!
@GoodlyChandeep
@GoodlyChandeep Год назад
Thank you!
@MrKamranhaider0
@MrKamranhaider0 Год назад
Just amazing
@GoodlyChandeep
@GoodlyChandeep Год назад
Thank you!
@annaperepechko537
@annaperepechko537 Год назад
Thank you!
@GoodlyChandeep
@GoodlyChandeep Год назад
💚
@aneeza6259
@aneeza6259 Год назад
Phenomenal
@GoodlyChandeep
@GoodlyChandeep Год назад
Thanks!
@cristian.angyal
@cristian.angyal Год назад
Great intro to M! Really good explanations and a MUST WATCH video for PQ learners! Thanks for sharing Chandeep!
@hugomelgar5046
@hugomelgar5046 Год назад
Awesome video¡
@GoodlyChandeep
@GoodlyChandeep Год назад
Thanks Hugo!
@tariqhussain1497
@tariqhussain1497 2 месяца назад
Good morning, i was looking for M Language code and good i find this and learn things in that
@thebhaskarjoshi
@thebhaskarjoshi Год назад
Really Amazing..
@GoodlyChandeep
@GoodlyChandeep Год назад
Thank you!
@user-lm5wb8vi1x
@user-lm5wb8vi1x 3 месяца назад
finished watching
@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 😊
@lokesh221188
@lokesh221188 Год назад
Amazing episode ☺️
@GoodlyChandeep
@GoodlyChandeep Год назад
Thank you!
@vigneshkumar8720
@vigneshkumar8720 Год назад
I was waiting for this one 🙌
@GoodlyChandeep
@GoodlyChandeep Год назад
Glad your wait is over 💚
@dhirendramaurya5361
@dhirendramaurya5361 Год назад
Nice explained
@GoodlyChandeep
@GoodlyChandeep Год назад
Thank you!
@josealvesferreira1683
@josealvesferreira1683 Год назад
very good
@GoodlyChandeep
@GoodlyChandeep Год назад
Thank you!
@carajeevrajan6565
@carajeevrajan6565 Год назад
Thanks
@GoodlyChandeep
@GoodlyChandeep Год назад
💚
@Seftehandle
@Seftehandle Год назад
is there any simpler video. this is great 👍 i just need it more simple
@manishankarmadishetty7548
@manishankarmadishetty7548 3 месяца назад
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.
@Rice0987
@Rice0987 Год назад
May i see a video with transformations of nested tables inside of a table column and further extraction of them? :)
@garylhaas2005
@garylhaas2005 Год назад
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.
@sujit3375
@sujit3375 Год назад
Complete course needed
@abdulrehman56
@abdulrehman56 Год назад
Great explanation I watched full video with being a bored for 1 second
@GoodlyChandeep
@GoodlyChandeep Год назад
Thank you! Glad you like it!
Далее
5 Surprising Power Query Tricks You Need to Know!
14:14
Une voiture originale 😂😂😂
00:38
Просмотров 948 тыс.
Power Query - Avoid "Helper Queries" (+10 Cool Tricks)
18:40
each & underscore_  in Power Query Explained
9:58
Просмотров 43 тыс.
How to learn Power BI in 2024 | Step by Step Guide
19:40
The Magic of working with Records in Power Query
10:28
Use CONCATENATEX to Create Smart Visuals in Power BI
20:02
5 Best Practices in Power Query
11:31
Просмотров 46 тыс.
Learn Power Query's M Language in 2024
9:32
Просмотров 18 тыс.