Power QueryExercises

each

Shorthand for a function with one parameter named _. each [Qty] * 2 means (_) => _[Qty] * 2.

each is used wherever a function takes another function: filter conditions, custom columns, transforms. Inside it, [Column] reads a field of the current row because it's short for _[Column]. Without each, M looks for a value called _ that doesn't exist and raises an error.

In the Power Query editor

Dialogs such as Filter Rows and Custom Column generate each expressions; you see them in the formula bar.

Learn more

Practise it

Related terms