Power QueryExercises

Underscore (_)

The implicit parameter created by each. In row functions it's the current row record; in Table.TransformColumns it's the current cell value.

What _ holds depends on the function that calls it: a row record in Table.SelectRows and Table.AddColumn, a single cell value in Table.TransformColumns, a list item in List.Transform, and a group's table in Table.Group aggregations. Reading the function's documentation tells you which.

In the Power Query editor

Generated steps like Table.TransformColumns(Source, {{"Name", Text.Trim}}) pass _ implicitly; custom code writes each Text.Trim(_).

Learn more

Practise it

Related terms