Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Power Query Complete M Code Introduction - Values, Let, Lookup, Functions, Parameters, More

ExcelIsFun via YouTube

Start learning Write review

Details

Start learning

Provider

YouTube
Pricing

Free Video
Languages

English
Effort

1 hour 7 minutes
Sessions

Self-Paced
Level

Intermediate

Found in

Power Query Courses

This course introduces the M language behind Power Query. It covers editing generated code, let expressions, values, lookups, primary keys, custom functions, parameter queries, and the underscore character.

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.