Lists in Power Query can be imagined as a list of numbers, texts or other objects.

Lists are written in braces like this:

  • {1,5,a,b}

Lists can be created directly by writing of items

  • ={1,2,3,4}

Or, typically, as a reference of table column:

  • =my_table[my_column]