Power QueryExercises

let expression

An M construct that binds names to values and returns one of them after in. Applied steps are the bindings of a let expression.

Each name in a let is a binding, separated by commas, and the expression after in is the result. Names can refer to any other binding, not just the one above, which is why a query can return an earlier step for debugging. Names with spaces are written as #"Name".

let
    Source = Orders,
    Filtered = Table.SelectRows(Source, each [Qty] > 0)
in
    Filtered

In the Power Query editor

Open the Advanced Editor: a typical query is one let expression whose bindings are the applied steps.

Learn more

Practise it

Related terms