Referencing a table and column together (a table-column reference) constructs a list of all values in that column of that table. Note that if the column itself contains duplicate values, so will the list.

  • Fruits[Name] produces a list of all Name column values from the Fruits table. This is equivalent to SELECT(Fruits[name], TRUE, FALSE). See also SELECT().
  • Orders[Customer] produces a list of all Customer column values from the Orders table. Equivalent to SELECT(Orders[Customer], TRUE, FALSE).
  • Order Details[SKU] produces a list of all SKU column values in the Order Details table. Equivalent to SELECT(Order Details[SKU], TRUE, FALSE).

A table-column reference to a column of type List or EnumList will produce a list of lists. To "flatten" the list-of-lists into a single list composed of the values of the component lists, wrap the table-column reference with SPLIT().

  • SPLIT(Employees[Vacation Dates], ",") produces a list of all employee vacation dates.
  • SPLIT(Events[Notification Emails], ",") produces a list of all notification email addresses.

See Also

List Expressions, List from Expressions, List from Values, List Subtraction, SELECT(), UNIQUE()

Did this answer your question?