NEW! FREE 30 Minutes MS Excel - Working with Dates Course  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.

SELECT COLUMN TO CREATE LIST QUERY

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.

CREATING A LIST QUERY

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.

AFTER CREATING A LIST QUERY

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.