Power BI Create Table From Another Table

Do you know that we can create a new table from an existing one in Power BI? If you don’t know how to create a new table from the existing one in Power BI, then this Power BI Tutorial might help you solve it.

Here I have explained how to create a table from another table with an example. Also, covered the below-mentioned topics:

  1. Power bi create table from another table
  2. Power bi create a new table with 2 columns from another table
  3. Power bi create a table from another table with filters
  4. Power bi create Calculated table from another table
  5. Power bi create table from another table selected columns
  6. Power bi create date table from another table
  7. Power bi create a table from another table to summarize
  8. Power bi create table from another table power query
  9. Power bi create table from another table with condition
  10. Power bi create a table from another table group by
  11. Power bi create a table from another table using DAX
  12. Power bi creates a table from another table without duplicates
  13. How to replace a table with another table in Power BI

Power bi create table from another table

Let us see how we can create a table from another table in Power BI,

For all the examples in this post, I have used the below-mentioned Product Table data to create a new table from an existing table in Power BI.

Power bi create table from another table
Power bi create table from another table
  • Load the data into the Power BI desktop, In the ribbon, select the Table tools and click on the New Table as shown below:
Power bi create table from another table example
Power bi creates a table from another table example
  • In the formula bar, apply the below-mentioned DAX formula to it and click on the check icon. We can rename the Table name as per the requirement.
New Table = SUMMARIZE(Sales_Table,Sales_Table[Product Name])

Where,

  1. New Table = New Calculated Table,
  2. Sales_Table = Old Table,
  3. Product Name = Old Column Name
  • In the below screenshot, you can see that under the Fields section New calculated table has been added with One Column from another table.
Power bi create a new table with one column from another table
Power bi create a new table with one column from another table

This is how to create a table from another table in Power BI.

Also Read: Power BI Compares Two Columns in Different Tables

Power bi create a new table with 2 columns from another table

Let us see how we can create a new table with 2 columns from another table in Power BI,

In this example, I have used the below-mentioned Product Table data to create a new table from an existing table with two columns in Power BI,

  • Load the data into the Power BI desktop, In the ribbon, select the Table tools and click on the New Table option.
  • In the formula bar, apply the below-mentioned DAX formula to create a new table with two columns and click on the check icon.
Table with 2 columns = SUMMARIZE(Sales_Table,Sales_Table[Product Name],Sales_Table[Sales])

Where,

  1. Table with 2 columns = New Calculated Table,
  2. Sales_Table = Old Table,
  3. Product Name & Sales = Old Column Name
  • In the below screenshot, you can see that under the Fields section New calculated table called Table with 2 columns has been added with two Columns from another table.
Power bi create a new table with 2 columns from another table
Power bi create a new table with 2 columns from another table

This is how to create a new table with 2 columns from another table in Power BI.

Check out: Power BI Sum Group by

Power bi create a table from another table with filters

Let us see how we can create a new table from another table with a filter function in Power BI,

  • In this example, I have used the Product Table data to create a new table from an existing table in Power BI.
  • Here I going to filter the product called Laptop separately from the Product table data and store it in the new table called Sub Table A. In the same way, I am going to filter the product called Desktop separately from the Product table data and store them in the new table called Sub Table B.
  • Load the data into the Power BI desktop, In the ribbon, select the Table tools and click on the New Table option.
  • In the formula bar, apply the below-mentioned DAX formula to filter the Product called Laptop and store it in Sub Table A.
SubTable A = CALCULATETABLE(Sales_Table,FILTER(Sales_Table,Sales_Table[Product Name]="Laptop"))

Where,

  1. SubTable A = New Calculated Table,
  2. Sales_Table = Old Table,
  3. Product Name = Old Column Name
  4. Laptop = Product Name

In the below screenshot, you can see that under the Fields section New calculated table called SubTable A has been added and filtered only the Product called Laptop from another or existing table.

Power bi create a table from another table with filters
Power bi create a table from another table with filters
  • In the same way, apply the below-mentioned DAX formula to filter the Product called Desktop and store it in Sub Table B.
SubTable B = CALCULATETABLE(Sales_Table,FILTER(Sales_Table,Sales_Table[Product Name]="Desktop"))

Where,

  1. SubTable B = New Calculated Table,
  2. Sales_Table = Old Table,
  3. Product Name = Old Column Name
  4. Desktop= Product Name

In the below screenshot, you can see that under the Fields section New calculated table called SubTable B has been added and filtered only the Product called Laptop from another or existing table.

Power bi create a table from another table with filters example
Power bi creates a table from another table with filters example

This is how to create a new table from another table with a filter function in Power BI.

Read: Power BI Report Export to PDF [With 20+ Examples]

Power bi create Calculated table from another table

Let us see how we can create a new calculated table from another table in Power BI,

In this example, I have used the Product Table data to create a new Calculated table from an existing table in Power BI,

  • Load the data into the Power BI desktop, In the ribbon, select the Table tools and click on the New Table option.
  • In the formula bar, apply the below-mentioned DAX formula to create a new calculated table from another table and click on the check icon.
Calculated Table = UNION('SubTable A', 'SubTable B')

Where,

  1. Calculated Table = Old Table
  2. SubTable A, SubTable B = New Calculated Table

In the below screenshot, you can see that under the Fields section newly created calculated Table united Sub Table A and Sub Table B.

Power bi create Calculated table from another table
Power bi create Calculated table from another table

This is how to create a calculated table from another table in Power BI.

Check: Power BI Add Calculated Column [With Various Examples]

Power bi create table from another table selected columns

Let us see how to create a table from another table for selected columns in Power BI,

In this example, I have used the Product Table data to create a new table from an existing table in Power BI, And also I’m going to select only selected columns called Product Name, Sales, Profit, and Customer Name.

  • Load the data into the Power BI desktop, In the ribbon, select the Table tools and click on the New Table option.
  • In the formula bar, apply the below-mentioned DAX formula to create a new table only with selected columns and click on the check icon.
Selected columns = SUMMARIZE(Sales_Table,Sales_Table[Product Name],Sales_Table[Sales],Sales_Table[Profit],Sales_Table[Customer Name])

Where,

  1. Selected columns = New Calculated Table,
  2. Sales_Table = Old Table,
  3. Product Name, Sales, Profit & Customer Name = Old Columns Name
  • In the below screenshot, you can see that under the Fields section New calculated table called Selected Columns has been added from another table.
Power bi create table from another table selected columns
Power bi create table from another table selected columns

This is how to create a table from another for selected columns in Power BI.

Check out: How to Append Columns in Power Query

Power bi create date table from another table

Let us see how we can create a date table from existing or another table in Power Bi,

In this example, I have used the Product Table data to create a date table from an existing table in Power BI,

  • Load the data into the Power BI desktop, In the ribbon, select the Table tools and click on the New Table option.
  • In the formula bar, apply the below-mentioned DAX formula to create a new date table and click on the check icon.
  • Here Order date column extracts the date, month, and year from the existing table to the new table.
Date Table = SUMMARIZE(Sales_Table,Sales_Table[Product Name],Sales_Table[Order Date].[Date],Sales_Table[Order Date].[Month],Sales_Table[Order Date].[Year])

Where,

  1. Date Table= New Calculated Table,
  2. Sales_Table = Old Table,
  3. Product Name, Order Date.Date, Order Date.Month, Order Date.Year = Old Columns Name
  • In the below screenshot, you can see that under the Fields section New calculated Date table has been added from another table.
Power bi create date table from another table
Power bi create date table from another table

This is how to create a date table from another table in Power Bi.

Also check out: Power BI Matrix Multiple Column

Power bi create a table from another table to summarize

Let us see how to create a new summarized table from the existing table in Power BI,

In this example, I have used the Product Table data to create a new summarized table from an existing table in Power BI,

  • Load the data into the Power BI desktop, In the ribbon, select the Table tools and click on the New Table option.
  • In the formula bar, apply the below-mentioned DAX formula to create a new summarized table and click on the check icon.
Summarized Table = SUMMARIZE(Sales_Table,Sales_Table[Product Name],Sales_Table[Units Delivered],Sales_Table[Order Date],Sales_Table[Customer Location])

Where,

  1. Summarized Table = New Calculated Table,
  2. Sales_Table = Old Table,
  3. Product Name, Units Delivered, Order Date & Customer Location= Old Columns Name
  • In the below screenshot, you can see that under the Fields section New calculated table called the summarized table has been added from another table.
Power bi create a table from another table to summarize example
Power bi create a table from another table to summarize example

This is how to create a new summarized table from the existing table in Power BI.

Read: How to remove rows in power query editor [With various examples]

Power bi create table from another table power query

Let us see how we can create a table from another table using the Power Query editor in Power BI,

In this example, I have used the Product Table data to create a new table from an existing table using the Power Query editor in Power BI,

  • Load the data into the Power BI desktop, In the ribbon, under the Home option click on the Transform data as shown below:
Power bi create table from another table power query
Power bi create table from another table power query
  • In the Power Query editor, Under the query section, simply right-click and select New Query -> Blank Query option as mentioned below:
Power bi how to create table from another table power query
Power bi how to create table from another table power query
  • In the formula section, write the below-highlighted query, where it takes data from the existing table,
= #"Sales_Table"[Product Name]

Here, Sales Table = Old Table Name and the Product Name is column Name.

  • In the below screenshot, you can see that the new query has been executed and retrieved the data from the existing table.
  • In the Power Query editor ribbon, select the Covert To Table option as highlighted below:
Power bi create table from another table power query example
Power bi create table from another table power query example
  • In the To Table Pop up, click on the Ok button, and it will automatically convert the Query to the Table.
Power bi how to create table from another table power query example
Power bi how to create table from another table power query example
  • In the below screenshot, we can see that the Query list has been converted to the table, we can also see that the table icon is presented.
  • If we want more columns then in the Query we can add the column names and execute it. If we want to rename the Query Table name, we can rename it by choosing rename option.
  • Click the close and Apply option so that the changes will appear on the Power Bi desktop.
Power bi create table from another table using power query
Power bi create table from another table using power query

This is how to create a table from another table using the Power Query editor in Power BI.

Check: Power BI filter between two dates [With 15+ Examples]

Power bi create table from another table with condition

Let us see how to create a new table from the existing table with conditions in Power BI,

In this example, I have used the Product Table data to create a new table from an existing table with conditions in Power BI,

  • Load the data into the Power BI desktop, In the ribbon, select the Table tools and click on the New Table option.
  • In the formula bar, apply the below-mentioned DAX formula to create a new table and click on the check icon.
Condition Table = CALCULATETABLE(Sales_Table,Sales_Table[Product Name]="TV")

Where,

  1. Condition Table = New Calculated Table,
  2. Sales_Table = Old Table,
  3. Product Name = Old Columns Name

In the below screenshot, you can see that under the Fields section New calculated table with conditions has been added from another table.

Power bi create table from another table with condition
Power bi create table from another table with condition

This is how to create a new table from the existing table with conditions in Power BI.

Power bi create a table from another table group by

Let us see how to create a new table using group by function from the existing table in Power BI,

In this example, I have used the Product Table data to create a new table by using Group by function from an existing table in Power BI to count the sales that happened based on the Products,

  • Load the data into the Power BI desktop, In the ribbon, select the Table tools and click on the New Table option.
  • In the formula bar, apply the below-mentioned DAX formula to create a new table by using Group by function and clicking on the check icon.
  • If we are using the GroupBy function, then we have used the CurrentGroup function so that it will calculate the value and display them in the new calculated table.
GroupBY = GROUPBY(Sales_Table,Sales_Table[Product Name],"Sales Count",COUNTX(CURRENTGROUP(),COUNT(Sales_Table[Sales])))

Where,

  1. GroupBY = New Calculated Table,
  2. Sales_Table = Old Table,
  3. Product Name, Sales= Old Columns Name
  • In the below screenshot, you can see that under the Fields section New calculated table called the GroupBy has been added from another table.
Power bi create a table from another table group by
Power bi create a table from another table group by

This is how to create a new table using group by function from the existing table in Power BI.

Read: Power BI Sum Multiple columns [With 21 Useful Examples]

Power bi create a table from another table using DAX

Let us see how to create a new table using DAXfrom the existing table in Power BI,

In this example, I have used the Product Table data to create a new table by using the DAX function from an existing table in Power BI. Here I have two tables, One is SubTable 1 and the other one is SubTable 2.

Sub Table 1

Power bi create a table from another table using DAX
Power bi create a table from another table using DAX

Sub Table 2

Power bi create a table from another table using measure
Power bi create a table from another table using a measure
  • Load the data into the Power BI desktop, In the ribbon, select the Table tools and click on the New Table option.
  • In the formula bar, apply the below-mentioned DAX formula to create a new table and click on the check icon it will combine and returns the SubTable 1 data and Sub Table 2 data by using the Union function.
Union = 
VAR STB1 =
 SELECTCOLUMNS ('SubTable A',"Products",'SubTable A'[Product Name],"Sales",'SubTable A'[Sales])
VAR STB2 =
 SELECTCOLUMNS ('SubTable B',"Tab2Product",'SubTable B'[Product Name],"1",'SubTable B'[Sales])
RETURN
UNION ( STB1, STB2 )

Where,

  1. Union = New Calculated Table,
  2. SubTable A,SubTable B = Old Table Names,
  3. Product Name,Sales = Old Columns Name

In the below screenshot, you can see that under the Fields section New calculated table using the DAX function has been added from another table.

Power bi create a table from another table using DAX example
Power bi create a table from another table using DAX example

This is how to create a new table using DAXfrom the existing table in Power BI.

Power bi creates a table from another table without duplicates

Let us see how to create a table from another table without duplicates in Power BI,

In this example, I have used the Product Table data to create a new table without any duplicated values or duplicated rows from an existing table in Power BI,

  • We can use the Distinct function to calculate the unique values in Power BI and display them in the new table.
  • Load the data into the Power BI desktop, In the ribbon, select the Table tools and click on the New Table option.
  • In the formula bar, apply the below-mentioned DAX formula to create a new table without duplicate values and click on the check icon.
DISTINCT = 

DISTINCT(SELECTCOLUMNS(CALCULATETABLE( Sales_Table,FILTER(Sales_Table,Sales_Table[Product Name]="Laptop")),"Product Name",'Sales_Table'[Product Name],"Sales",Sales_Table[Sales],"date",Sales_Table[Order Date]))

Where,

  1. DISTINCT = New Calculated Table,
  2. Sales_Table = Old Table Names,
  3. Product Name,Sales & Order Date = Old Columns Name

In the below screenshot, you can see that under the Fields section New calculated table has been added without any duplicated values because the DISTINCT function returns only unique values from another table.

Power bi creates a table from another table without duplicates
Power bi creates a table from another table without duplicates

This is how to create a table from another table without duplicates in Power BI.

Read: Power BI divides two columns [With 14 real examples]

How to replace a table with another table in Power BI

Let us see how we can replace table values with another table value in Power BI,

In this example, I have used the below-mentioned two tables, to replace a table with another table in Power BI.

Table 1:

How to replace a table with another table in Power BI
How to replace a table with another table in Power BI

Table 2:

replace a table with another table in Power BI
replace a table with another table in Power BI
  • Load the data into the Power BI desktop, In the ribbon, under the Home option click on the Transform data.
  • In the Power Query editor, click on the Appended Queries option in the ribbon as highlighted below:
  • Select the Sheet that you want to append with and click on the Ok button.
replace table with another table in the Power BI
replace the table with another table in the Power BI
  • Once the Query has replaced with the values, Right click on it and select the remove duplicates option as shown below:
How to replace a table with another table in Power BI example
How to replace a table with another table in Power BI example
  • In the below screenshot, you can see that it combines the two table values, and replaced them with the unique values in another table in Power BI using the Power Query editor.
replace a table with another table in Power BI example
replace a table with another table in the Power BI example

This is how to replace table values with another table value in Power BI.

Also, you may like some more Power BI Tutorials:

In this tutorial we have learned how we can create a table from another table or existing table in Power BI, Also, we covered all these below-related topics:

  • Power bi create a new table with 2 columns from another table
  • Power bi create a table from another table with filters
  • Power bi create Calculated table from another table
  • Power bi create table from another table selected columns
  • Power bi create date table from another table
  • Power bi create a table from another table to summarize
  • Power bi create table from another table power query
  • Power bi create table from another table with condition
  • Power bi generates a table from another table group by
  • Power bi create a table from another table using DAX
  • Power bi creates a table from another table without duplicates
  • How to replace a table with another table in Power BI
  • HI, WHEN ADDING A COLUMNS IN THE QUERY EDITOR, HOW CAN I ADD MORE THAN 1? HOW IS THE SYNTAX FOR IT?

    = #”LND_SPF_PDREPORT”[Qtr Year Query] + COLUMN 2, 3, 4, ETC

    (IN HERE)
    If we want more columns then in the Query we can add the column names and execute it.

  • when I use your method in “Power bi create table from another table selected columns” all the duplicated rows are gone

  • >