Dive into a comprehensive video tutorial on Power Query's M Code, exploring its fundamental concepts and advanced techniques. Learn to edit M Code through Applied Steps, Formula Bar, and Advanced Editor. Understand expressions, including 'let' expressions, and how to add comments. Explore various data types like primitive values, lists, records, tables, and functions. Master lookup operations, including Row Index and Key Match lookups, and grasp the importance of primary keys. Discover how to create custom functions and implement parameter queries. Gain insights into the underscore character's usage in M Code. Access provided Excel files and PDF notes to enhance your learning experience and practice your newly acquired M Code skills through assigned homework exercises.
Power Query Complete M Code Introduction - Values, Let, Lookup, Functions, Parameters, More
ExcelIsFun via YouTube
Overview
Syllabus
) Introduction.
) Edit M Code: Applied Steps.
) Edit M Code: Formula Bar.
) Edit M Code: Advanced Editor.
) Expressions.
) let expressions.
) Comments in M Code.
) Values: Primitive, List, Record, Table, Function.
) Lookup or Projection and Selection. Learn about Row Index Lookup and Key Match lookup.
) Primary Keys, including Table.AddKey function..
) Custom Functions.
) Parameter Queries.
) Underscore Character _.
) Summary.
Taught by
ExcelIsFun
Related Courses
-
Master Power Query M Code and Data Shaping for Data Analysis
-
M Code Class from Basic to Advanced - Power Query Excel & Power BI, Custom Functions
5.0 -
All Important Excel Lookup Formulas - Excel Worksheet, Power Query & DAX – 28 Examples
-
Approximate Match Lookup in Power Query - Amazing Functions for Power BI and Excel
-
Lookup Functions and Formulas in Excel 2016 - Comprehensive Lessons with 20 Examples
-
Excel at Microsoft Excel - The Complete Beginner to Advanced Excel Mastery Course -
