How can I create a table in Power BI by using DAX from another table?

By /

In order to create a table in Power BI using DAX from another table, follow these steps:

1. Start by selecting the “Data” tab and then click on “New Table” option.
2. In the formula bar, type in the DAX formula to define the new table.
3. Use the “FILTER” function to specify the table you want to use as the source.
4. Add any additional conditions or filters to the formula, if needed.
5. Name the new table by typing the desired name in the formula bar.
6. Click on the check mark to validate the formula and create the new table.
7. The new table will now appear in the “Fields” pane and can be used in your Power BI reports.

By using DAX to create a new table from an existing one, you can easily manipulate and organize your data in Power BI for more effective analysis and visualization.

Power BI: Create Table from Another Table by Using DAX

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:

x

Related terms:

  1. How can I create a table from another table using DAX in Power BI?
  2. How can I create a table in Power BI using DAX?
  3. How can I use DAX to create a table in Power BI?
  4. How can I create a frequency table in SPSS and what is an example of a frequency table?
  5. How do I create a pivot table in Power BI, and what is an example of how it can be used?
  6. How do I create a Pivot Table in Power BI? (With Example)
  7. How to Convert a Pivot Table to a Table in Excel
  8. How can I convert a pivot table to a table on Google Sheets?
  9. How can I transpose a table in Power BI?
  10. How can I remove column headers in a table in Power BI?