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
- intermediate~9 minPro
Build a one-row summary table in M (kite shop)
Write a let expression that computes order count, total quantity and the largest unit price, returned as a one-row table.
- intermediate~9 minPro
Build a calendar from the first to the last order date (kite shop)
Create a table with one row for every day from the earliest to the latest order date, including days with no orders.
- beginner~6 minPro
Turn a settings object into a Name/Value table (report config)
A JSON settings file is a single object. List its settings as rows with Name and Value columns.
- intermediate~7 minPro
Find customers who ordered in January but not in February (kite shop)
Compare the customer lists of two months and return the customers who didn't come back.