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/AllClasses/348/MSPTDA/Content/PowerQuery/009-MSPTDA-ValuesExpressionsFunctions-Start.xlsx Zipped Folder: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/009-ParameterQueryTables.zip Download Excel FINISHED Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/009-MSPTDA-ValuesExpressionsFunctions-Finished.xlsx Download pdf Notes about Power Query: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/009-MSPTDA-ValuesExpressionsFunctions.pdf Assigned Homework - these are problems for you to practice your new M Code skills: Download Excel File with Homework: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/009-MSPTDA-Homework-Start.xlsx Example of Finished Homework: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/009-MSPTDA-Homework-Finished.xlsx 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.