Lists in Power Query

A list in Power Query has only a single column of data, whereas a table can contain more than one column also. The list can be created manually using the curly brackets ({}). The values are separated by commas.

Syntax

= {Value1, Value2, Value3, Value4…}

Example: Following is the list of country values.

Power Query M

= {"India", "America", "Canada", "Japan", "Australia", "England"}

The output of the above code is shown below:

Lists in Power Query