← All courses
FREN

M language: lists, records and functions

Move from the interface to the code: each and _, lists, records, List.Accumulate, nested tables and custom functions.

20
modules
≈ 8 h
of training
€500
the full course, incl. VAT
Start for free

Access: an e-mail address is enough, you receive a sign-in code. Free modules need no bank card.

What you will be able to do

  • Understand each and _ and read the M code generated by the interface
  • Navigate records and handle lists: Contains, Distinct, Union, Intersect…
  • Make queries dynamic, with no hard-coded columns or names
  • Transform rows and add columns in bulk with Table.TransformRows and List.Accumulate
  • Work with nested tables and write a dynamic, unbreakable typing function
  • Go further: the ?? operator, Expression.Evaluate, calling an AI API, commented code

Who it is for

Power Query users comfortable with the interface who want to write and understand M code.

Prerequisites

The “Power Query: the fundamentals” course or equivalent practice (applied steps, advanced editor, custom columns).

Included

  • Video with chapters
  • PDF slides
  • Marked quiz
  • Verifiable certificate

Programme

Intermediate

  1. 01Understanding each and _ (underscore) in the M language22 min10-question quizFree
  2. 02Records: navigating, creating and using them25 min10-question quiz€50 incl. VAT
  3. 03List functions: Contains, Count, Distinct, Union, Combine27 min10-question quiz€50 incl. VAT
  4. 04Comparing lists: Intersect, Difference, ContainsAny25 min10-question quiz€50 incl. VAT
  5. 05Using lists to make your queries dynamic33 min10-question quiz€50 incl. VAT
  6. 06Replacing values conditionally (Table.ReplaceValue)23 min10-question quiz€50 incl. VAT
  7. 07Grouping columns into a record (CombineColumnsToRecord)20 min10-question quiz€50 incl. VAT
  8. 08Documenting your M code with an AI assistant18 min10-question quiz€50 incl. VAT

Advanced

  1. 09Transforming rows with Table.TransformRows27 min10-question quiz€50 incl. VAT
  2. 10Decoding List.Accumulate step by step21 min10-question quiz€50 incl. VAT
  3. 11Adding columns dynamically with List.Accumulate23 min10-question quiz€50 incl. VAT
  4. 12Dynamic sums and % columns (List.Sum, List.Accumulate)28 min10-question quiz€50 incl. VAT
  5. 13Selecting the month columns without hard-coding21 min10-question quiz€50 incl. VAT
  6. 14Underlying tables: three ways to combine a folder25 min10-question quiz€50 incl. VAT
  7. 15Nested tables: working on several levels28 min10-question quiz€50 incl. VAT
  8. 16Dynamic column typing with a function26 min10-question quiz€50 incl. VAT
  9. 17Unbreakable typing: ignoring missing columns20 min10-question quiz€50 incl. VAT
  10. 18Handling nulls with the ?? operator (coalescing)32 min10-question quiz€50 incl. VAT
  11. 19Formulas stored as text: Expression.Evaluate24 min10-question quiz€50 incl. VAT
  12. 20Querying the OpenAI API from Power Query21 min10-question quiz€50 incl. VAT
Start for free

Training a team? Access for several employees, on quotation. admin@axent-consulting.com