Power QueryExercises

List

An ordered sequence of values, written {1, 2, 3}. Table[Column] returns a column as a list.

Lists hold any values, including other lists, and items are read by position starting at 0: list{0}. Ranges such as {1..10} or {"a".."z"} build lists quickly. Most aggregation functions, from List.Sum to List.Max, take a list, and List.Transform applies a function to every item to build a new one.

In the Power Query editor

A list column shows List in each cell; Expand to New Rows turns each item into its own row.

Learn more

Related functions

Practise it

Related terms