Table of Contents
In order to create a table from another table using DAX in Power BI, you can use the “SUMMARIZE” function. This function allows you to group and summarize data from an existing table, and create a new table with the specified columns and calculations. You can also use other DAX functions like “CALCULATETABLE” or “FILTER” to further manipulate the data and create the desired table. This method allows you to easily create new tables with aggregated or filtered data from an existing table, saving time and effort in data analysis.
You can use the following syntax in DAX to create a table from another existing table in Power BI:
New_Data = SELECTCOLUMNS( My_Data, "Team", [Team], "Points", [Points])
This particular example creates a new table named New_Data that contains the columns named “Team” and “Points” from the existing table named My_Data.
The following example shows how to use this syntax in practice.
Example: How to Create Table from Another Table Using DAX
Suppose we have the following existing table in Power BI named my_data:
Suppose that we would like to create a new table that contains just the Team and Points columns from the My_Data table.
To do so, click the Table Tools tab, then click the New table icon:
Next, type the following formula into the formula bar:
New_Data = SELECTCOLUMNS( My_Data, "Team", [Team], "Points", [Points])
Once you press Enter, a table named New_Data will be created that contains only the Team and Points columns from the existing table named My_Data:
Note that you can also specify new column names to use in the new table if you’d like.
For example, we could use the following syntax to rename the columns Team_Name and Points_Scored:
New_Data = SELECTCOLUMNS( My_Data, "Team_Name", [Team], "Points_Scored", [Points])
Note: You can find the complete documentation for the SELECTCOLUMNS function in DAX .
Additional Resources
The following tutorials explain how to perform other common tasks in Power BI: