Power QueryExercises

Custom function

A reusable function you define in M with =>, such as (qty, region) => …, then invoke from other steps.

A function query can be invoked on every row with Invoke Custom Function, which is how Combine Files works. Parameters can be typed (amount as number) so wrong inputs fail clearly. Functions keep repeated logic in one place, so a fix applies everywhere.

In the Power Query editor

A query whose result shows Enter Parameters; Add Column → Invoke Custom Function calls it per row.

Learn more

Practise it

Related terms