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.