Dive into a comprehensive video tutorial on M Code for Power Query in Excel and Power BI, ranging from basic to advanced concepts. Learn about M Code fundamentals, Power Query Editor, let expressions, data types, and various M Code values. Explore advanced topics such as lookups, custom functions, and approximate match techniques. Gain practical skills through numerous examples and hands-on exercises, guided by Excel MVP and Highline College Professor Mike Girvin. Perfect for data analysts and Excel power users looking to enhance their data manipulation and transformation capabilities.
M Code Class from Basic to Advanced - Power Query Excel & Power BI, Custom Functions
ExcelIsFun via YouTube
Overview
Syllabus
1. Introduction
2. Define M Code
3. Power Query and M Code are in Both Excel and Power BI Desktop
4. Advanced Editor button in Excel & Power BI Desktop
5. Power BI Desktop “Enable Load”
6. 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. M Code Identifiers and spaces.
8. let expression definition and structure.
9. Expressions
10. Insert or Delete Query let expression Steps: 2 possibilities.
11. #shared to show Standard Library in Power Query
12. Learn about 15 M Code Values: Null, Logical, Text, Number, Time, Date, DateTime, DateTimeZone, Duration, Table, Record, List, Binary, Function, Type
13. IF function and AND Function in M Code
14. Compare Excel Close & Load to Power BI Desktop Close & Apply
15. Copy and Paste Tables into Power BI Desktop.
16. Power Query Date and Duration Examples
17. Table Values
18. Record Values
19. List Values
20. Binary, Function and Type M Code Values
21. Data Types
22. Values Vs. Data Types
23. M Code Lookup: Two-way Lookup, Column Lookup, Row or Record lookup. Also know as: Projection lookup column and Selection lookup row
24. Diagrams for M Code Lookup
25. Row Index Lookup
26. Key Match Lookup
27. Drill Down, Primary Keys and Lookup
28. Custom Functions 5 examples to learn basics
29. Build reusable function.
30. Build Custom Function as a Query Step.
31. each and Underscore.
32. Approximate Match Lookup M Code Custom Function 4 examples
33. Full Video Summary and Conclusions
34. Closing and Video Links
Taught by
ExcelIsFun
Related Courses
Related articles
Reviews
5.0 rating, based on 1 Class Central review
-
Started this course because I was struggling working with M Code on Power BI. This course contains good description of M Code and I learnt a lot from this course.
