M Code Class from Basic to Advanced - Power Query Excel & Power BI, Custom Functions

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