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.
Data Analytics Tricks in Power BI – Guidebook
You too can analyze data like a Data Scientist. No coding needed. No statistics needed.
Analyze & Visualize data using Power BI. (23 tricks in one book)
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.
Data Analytics Tricks in Power BI – Guidebook
You too can analyze data like a Data Scientist. No coding needed. No statistics needed.
Analyze & Visualize data using Power BI. (23 tricks in one book)