Completed
1. Introduction
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
M Code Class from Basic to Advanced - Power Query Excel & Power BI, Custom Functions
Automatically move to the next video in the Classroom when playback concludes
- 1 1. Introduction
- 2 2. Define M Code
- 3 3. Power Query and M Code are in Both Excel and Power BI Desktop
- 4 4. Advanced Editor button in Excel & Power BI Desktop
- 5 5. Power BI Desktop “Enable Load”
- 6 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 7. M Code Identifiers and spaces.
- 8 8. let expression definition and structure.
- 9 9. Expressions
- 10 10. Insert or Delete Query let expression Steps: 2 possibilities.
- 11 11. #shared to show Standard Library in Power Query
- 12 12. Learn about 15 M Code Values: Null, Logical, Text, Number, Time, Date, DateTime, DateTimeZone, Duration, Table, Record, List, Binary, Function, Type
- 13 13. IF function and AND Function in M Code
- 14 14. Compare Excel Close & Load to Power BI Desktop Close & Apply
- 15 15. Copy and Paste Tables into Power BI Desktop.
- 16 16. Power Query Date and Duration Examples
- 17 17. Table Values
- 18 18. Record Values
- 19 19. List Values
- 20 20. Binary, Function and Type M Code Values
- 21 21. Data Types
- 22 22. Values Vs. Data Types
- 23 23. M Code Lookup: Two-way Lookup, Column Lookup, Row or Record lookup. Also know as: Projection lookup column and Selection lookup row
- 24 24. Diagrams for M Code Lookup
- 25 25. Row Index Lookup
- 26 26. Key Match Lookup
- 27 27. Drill Down, Primary Keys and Lookup
- 28 28. Custom Functions 5 examples to learn basics
- 29 29. Build reusable function.
- 30 30. Build Custom Function as a Query Step.
- 31 31. each and Underscore.
- 32 32. Approximate Match Lookup M Code Custom Function 4 examples
- 33 33. Full Video Summary and Conclusions
- 34 34. Closing and Video Links
