Power QueryExercises

Module 17

Functions, each and scope

each, custom functions, branching and error handling in M.

You'll be able to

Lessons

  1. 1.Write and use custom functionsDefine a function, give it typed parameters and call it from a custom column.
  2. 2.Row context: whole-table values and the previous rowCombine the current row with values from other rows in a custom column.
  3. 3.Raise and handle errors in your own functionsWrite functions that reject bad input with clear messages that callers can handle.
  4. 4.Scope, closures and List.AccumulateUse closures and accumulation to express rules that table steps can't.

Take the functions, each and scope quiz (8 questions)

Exercises