MSPTDA 09 Power Query Complete M Code Introduction: Values, let, Lookup, Functions, Parameters, More

Download Excel START Files: Excel Start: https://people.highline.edu/mgirvin/A... Zipped Folder: https://people.highline.edu/mgirvin/A... Download Excel FINISHED Files: https://people.highline.edu/mgirvin/A... Download pdf Notes about Power Query: https://people.highline.edu/mgirvin/A... Assigned Homework - these are problems for you to practice your new M Code skills: Download Excel File with Homework: https://people.highline.edu/mgirvin/A... Example of Finished Homework: https://people.highline.edu/mgirvin/A... In this Video learn the basics of M Code, the computer language behind queries in Power Query. Topics: 1. (00:15) Introduction 2. (03:46) Edit M Code: Applied Steps 3. (03:46) Edit M Code: Formula Bar 4. (03:46) Edit M Code: Advanced Editor 5. (09:50) Expressions 6. (09:50) let expressions 7. (17:34) Comments in M Code 8. (21:11) Values: Primitive, List, Record, Table, Function 9. (30:45) Lookup or Projection and Selection. Learn about Row Index Lookup and Key Match lookup 10. (42:50) Primary Keys, including Table.AddKey function. 11. (50:20) Custom Functions 12. (57:44) Parameter Queries 13. (01:02:27) Underscore Character _ 14. (01:06:17) Summary Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.