Free M Code Class from Basic to Advanced: Power Query Excel & Power BI, Custom Functions 365 MECS 12

This video is a comprehensive lesson in Power Query M Code in Excel & Power BI.

This video covers.
1. (00:00) Introduction
2. (00:26) Define M Code
3. (03:05) Power Query and M Code are in Both Excel and Power BI Desktop
4. (05:08) Advanced Editor button in Excel & Power BI Desktop
5. (05:39) Power BI Desktop “Enable Load”
6. (06:22) M Code Basics, tour of Power Query Editor and the three locations to view and change M Code. We use a Group By Query to learn about the basics of M Code.
7. (10:23) M Code Identifiers and spaces.
8. (14:21) let expression definition and structure.
9. (16:32) Expressions
10. (18:20) Insert or Delete Query (let expression) Steps: 2 possibilities.
11. (24:45) #shared to show Standard Library in Power Query
12. (26:32) Learn about 15 M Code Values: Null, Logical, Text, Number, Time, Date, DateTime, DateTimeZone, Duration, Table, Record, List, Binary, Function, Type
13. (33:15) IF function and AND Function in M Code
14. (36:23) Compare Excel Close & Load to Power BI Desktop Close & Apply
15. (38:45) Copy and Paste Tables into Power BI Desktop.
16. (39:35) Power Query Date and Duration Examples
17. (46:32) Table Values
18. (51:08) Record Values
19. (53:37) List Values
20. (59:05) Binary, Function and Type M Code Values
21. (59:40) Data Types
22. (59:40) Values Vs. Data Types
23. (01:01:38) M Code Lookup: Two-way Lookup, Column Lookup, Row (or Record) lookup. Also know as: Projection (lookup column) and Selection (lookup row)
24. (01:03:19) Diagrams for M Code Lookup
25. (01:06:04) Row Index Lookup
26. (01:07:15) Key Match Lookup
27. (01:08:55) Drill Down, Primary Keys and Lookup
28. (01:13:33) Custom Functions (5 examples to learn basics)
29. (01:17:50) Build reusable function.
30. (01:22:08) Build Custom Function as a Query Step.
31. (01:27:04) each and Underscore.
32. (01:29:47) Approximate Match Lookup M Code Custom Function (4 examples)
33. (01:39:13) Full Video Summary and Conclusions
34. (01:40:32) Closing and Video Links

#Girvin
#excelisfun
#M365
#MECS
#Microsoft
#MCode
#PowerQuery
#PowerBI
#DataMashup
#LearnMCode
#FreeMCodeClass
#LearnMCodeFast
#MCodeMadeEasy
#MCodeLanguage
#CustomFunctions
#MCodeCustomFunctions
#PowerQueryLookup
#MCodeLookup
#MCodeSpecifications
#datascience
#PowerQueryMCode
#DataAnalysis
#MicrosoftDataAnalytics
#PowerQueryMCode
#PowerBIMCode
#McodeAndDAX
#datacleaning
#datatransformation
#ETL
#advancedexcel
#mcode
#powerbi
#excel
#businessintelligence
#businessanalystcourse
#mcodetutorial
#mlanguage
#mlanguagetutorial
#powerbitutorial
#powerquerytutorial

[excelisfun]

Dataflows (Power Query Online) is introduced in the next video MECS #13 : )
There are a practice files for both Excel & Power BI Desktop! The practice files (homework) are in both files, but instructions are only in Excel file on the HW(1) worksheet.

[PavanLalwani]

Mike you are teaching the whole world directly by your videos, indirectly by teaching instructors like me who are carrying this legacy ahead.

You are truly amazing and best in the world . Inspiring !!!

[gvitullib]

In my opinion, the best Code M step by step course I have watched so far. This 365 MECS series are like top ranked Oscar´s awards movies. Thanks a lot Mike !!

[rrrprogram]

Top class video by a legendary man Mike for sharing...

[QuantumIdeas]

This is the most comprehensive Power Query/M Code video I've come across in Youtube so far, and I've already viewed weeks of Power Query/M Code videos already. I wish I came across this video a lot earlier and I could have saved a lot of wasted time.

[ruelformales]

Mike deserves all the praises in this comment. He is just in a different level!

[GameboyMufti]

Thanks for sharing, I am amazed how people like you are sharing such useful and precious knowledge for free.
Thanks once again for sharing.

[fnrcucb]

I just dropped out from one of the top universities here in Korea and now I am focusing all my time and efforts in learning every detail of your lectures and your book. The difference in the quality is so outstanding that I feel ashamed even trying to compare. Thank you so much for your knowledge and effort, and more importantly your passion. I want to go back in time and slap myself who thought Excel was nothing more than a boring technology. I am trying to move away from all the fancy software engineering, machine learning, ai trend that I blindly pursue and am planning to focus the next several years on understanding and mastering Excel. Thank you so much and I hope you have a great day

[qamaruddinkhichi]

I'm speechless to see your hardworking, dedication, enthusiasm, and unconditional support to help us.

Thanks a lot!

[excelisfun]

Dataflows (Power Query Online) is introduced in the next video MECS #13 : )

[hBrynx]

I’m glad I already watched your video on LAMBDA worksheet function. It really helped to link the related concepts from that video to this one. This is high quality learning material! 👏

[bucs]

This is 'next in line', excellence work of Mr Girvin. Tireless keeps giving us knowledge. Unbelievable. Thank You!

[joedi]

Mike honestly teaches for common person. I’ve paid for a lot of training and have learnt a lot but Mike just makes it so simple for all. If I ever visit the US, I’m taking this dude out for lunch!

[nadermounir]

The best Video on M-code on the Internet for sure. The PDF notes are superb. Couldn't have learned excel without Mike Girvin :)

[MerkDolf]

The good thing about epic videos are that you can go back over and over again, plus with the addition of time stamps great thank you very much.

[michaelt]

I am as excited about this series as I was when my wife gave me the Marvel Infiniti boxed series. You are a greater hero than any of them. Thank you!!

[HuTrzy]

It's hard for me to even express how grateful I am for such a great piece of work... Thank you so much !!!

[chrism]

Awesome Mike! I definitely need to get better with M code to take my PQ abilities to the next level. Thanks for another great video!

[roywilson]

Thanks for the interesting intro to M Code, it is certainly a powerful way to use the Power BI application to clean and prepare data ahead of analysis. Love the way you give clear and concise explanations with multiple examples and your boundless enthusiasm for the subject matter. I like that power query makes you think more about data types and how the data is structured versus how to achieve the required structure and have noticed that with the newer functions in Excel that Microsoft seem to be pushing for a more highly structured approach to data on the grid which can only be a good thing.

[KuldeepSingh-nqvi]

No other video is available like this in respect to M Language.. Thanks for making this descriptive video..