NEW! FREE 30 Minutes Excel Conditional Formatting for Beginners! Watch now 

Power BITutorials

Steps to Create A List Query From A Table Column

1 Mins read

Power Query also allows you to create a list query from a data table available. The column from the given data table can be used to create a list query. This can be explained with the help of an example.

Creating A List Query From A Table Column

Here, we have a data table containing product details. We want to create a new query for the column ProductName from this data table. To do so, we need to follow the below steps.

Step 1: Select the Column for creating List Query

First, load the data table ‘Products’ into the Power Query. Then, select the column ‘ProductName’ from the data table as shown below.


Step 2: Create a List Query

To create a list query from the selected column, right-click on the column and select ‘Add as New Query’ option as shown in the picture below.

NOTE: You can also use Table.ToList() function in Power Query (M) language for creating a list from a data table.


Step 3: Close & Apply

When you click on ‘Add as New Query’ option, Power Query immediately creates a new list Query for you as shown below. You can now Close & Apply the changes for the future.


You can learn more: 

Related posts
Power BITutorials

Opportunity Analysis Power BI Dashboard

1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…
Power BITutorials

Procurement Analysis Power BI Dashboard

1 Mins read
Information: It analyzes a manufacturing company’s spending on vendors by category and location. we explore these areas: Who the top vendors are…
Power BITutorials

Retail Analysis Power BI Dashboard

1 Mins read
Information: It analyzes retail sales data of items sold across multiple stores and districts The metrics compare this year’s performance to last…

1 Comment

Comments are closed.