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 in Power BI by Sindhu
234 views

1 answer 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.

answered Mar 14 by Cherukuri
• 17,870 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 in Power BI by Phalguni
• 1,010 points
37 views
+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,100 points

edited Oct 11, 2018 by Kalgi 114 views
0 votes
1 answer

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 in Power BI by Cherukuri
• 17,870 points
1,512 views
0 votes
1 answer

How to show filtered vs total data in power BI?

Hi sindhu, Follow below steps to show filtered ...READ MORE

answered Mar 26 in Power BI by Cherukuri
• 17,870 points
67 views
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,010 points
50 views
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,240 points
84 views
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,060 points
60 views
0 votes
1 answer

Unable to install connector for Power Bi and PostgreSQL

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

answered Aug 21, 2018 in Power BI by nirvana
• 3,060 points
483 views
0 votes
1 answer

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

Hi Nithin, It is easy and simple. 1. Go ...READ MORE

answered Mar 1 in Power BI by Cherukuri
• 17,870 points
76 views
0 votes
1 answer

How to Install Power BI in Windows

Hi, Anitha Go to this Link https://powerbi.microsoft.com/en-us/downloads/ Then click on ...READ MORE

answered Feb 28 in Power BI by Cherukuri
• 17,870 points
25 views