How to combine multiple tables in power BI

0 votes

I have three tables whose structure is as follows-

Table 1-

enter image description here

Table 2-

enter image description here

Table 3-

enter image description here

I wanted to have a table like this -

enter image description here

I tried this particular formula for creating a calculated table-

Table = UNION(SELECTCOLUMNS(Table1,"Table1", Tables[Table1]), SELECTCOLUMNS(Table2, "Table2 Totals", Table2[Totals]), SELECTCOLUMNS(Table3, "Table3 Totals", Table3[Totals]))

The result I am getting is like this:-

enter image description here

I have no idea why this is happening. What to do in this scenario? Do calculated columns not come in merge query?

Mar 14, 2019 in Power BI by Sindhu

4 answers to this question.

0 votes

Hi Sindhu,

You can merge the 3 tables into a new table to get the required output that you want.

1.  Merge TABLE1, TABLE2.  ---------->     NEW TABLE    [ columns - Table2, Name ]

2.  Select all column from TABLE1.  Select 1st and last column of TABLE2 IN THE NEW TABLE.

3.  Merge TABLE3, NEW TABLE  ------------->   NEW TABLE.     [ columns - Table3, Name ]

4.  Select only 1st column from TABLE 1 And last columns of TABLE  2, TABLE 3.

5.  You will get the required result.

Hope this helps you.

If you are interested in learning more about Power BI then check out Power BI Course Content now!

answered Mar 14, 2019 by Cherukuri
• 33,030 points
0 votes

Power BI Desktop you can join two tables with Merge menu item in the Query Editor, in Home tab, Under CombineMerge Queries. The Merge Window will appear with ability to select first table (Left part of the join), and the second table (Right part of the join).

Elevate your data analysis skills to expert levels with our in-depth Mastering Power BI Program. Gain the advanced expertise to analyze, visualize, and report data like a pro.

answered Dec 16, 2020 by Gitika
• 65,910 points
0 votes

Here are the steps to merge these tables:

  1. Click on the Data tab.
  2. In the Get & Transform Data group, click on 'Get Data'.
  3. In the drop-down, click on 'Combine Queries.
  4. Click on 'Merge'. ...
  5. In the Merge dialog box, Select 'Merge1' from the first drop down.
  6. Select 'Region' from the second drop down.

Unlock the full potential of your data visualization with custom tables in Power BI! Learn how to create tailored tables that suit your unique analytical needs and enhance your business insights. Start building your custom tables now!

answered Dec 16, 2020 by Rajiv
• 8,910 points
0 votes

Click Advanced Editor and check if step #"Appended Query" is like pattern below:

#"Appended Query"Table.Combine({#"Changed Type", Table2, Table3, ...}),
answered Dec 16, 2020 by Roshni
• 10,520 points

Related Questions In Power BI

0 votes
1 answer

How to combine your data or tables in Power BI?

Power BI includes Query Editor which is ...READ MORE

answered Feb 27, 2019 in Power BI by Phalguni
• 1,020 points
0 votes
1 answer

How to create Pivot Tables in Power BI?

Hey, First of all, there is no "Pivot ...READ MORE

answered Feb 6, 2020 in Power BI by Gitika
• 65,910 points
+3 votes
2 answers

Combine tables in Power BI

You can also achieve this using a ...READ MORE

answered Oct 5, 2018 in Power BI by lina
• 8,220 points

edited Oct 11, 2018 by Kalgi 2,214 views
+2 votes
3 answers

How to replace null values with custom values in Power BI(power query editor)?

Hi Nithin, To fill or replace the null or ...READ MORE

answered Mar 8, 2019 in Power BI by Cherukuri
• 33,030 points
0 votes
1 answer

How to merge data frames using joins?

You can use the merge function with ...READ MORE

answered Apr 12, 2018 in Data Analytics by kappa3010
• 2,090 points
0 votes
1 answer

Which query to use for better performance, join in SQL or using Dataset API?

DataFrames and SparkSQL performed almost about the ...READ MORE

answered Apr 19, 2018 in Apache Spark by kurt_cobain
• 9,390 points
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,130 points
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 22, 2018 in Power BI by nirvana
• 3,130 points
0 votes
3 answers

How to create final table based on Joins of two tables in power BI?

To do so, follow these steps: From the ...READ MORE

answered Dec 16, 2020 in Power BI by Gitika
• 65,910 points
0 votes
1 answer

How to Install Power BI in Windows

Hi, Anitha Go to this Link Then click on ...READ MORE

answered Feb 28, 2019 in Power BI by Cherukuri
• 33,030 points
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP