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

0 votes
I have 2 tables, city table and population table, i need to join them to show report. How to do this?
Mar 1, 2019 in Power BI by nithin
55,656 views

3 answers to this question.

0 votes

Hi Nithin,

It is easy and simple.

1. Go to Power BI, Get Data -> Data Source -> select the tables while fetching data sources, then click on edit option to perform any ETL operations.

2. You can see list of tables on left side pane of Power Query Editor window.

3.Click on merge option ( as new).

4.Select the 2nd table and select the column to join and the join kind .

5.The Key column is shown in new table with (table) entry.

6. Select the columns to select the columns to add in new table created after join. 

7. Columns are displayed as below. (<2nd table name>.<column name>). The new table can be renamed on the right side of the window.

hope this helps you. 

To master Power BI concepts, check out Power BI Training offered by Edureka.

answered Mar 1, 2019 by Cherukuri
• 33,030 points

I even tried opening the images in a new tab.

Hi @There,

ould you please explain your workaround what are you trying to do?

0 votes

In 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).

Learn How to combine multiple tables in Power BI?

answered Dec 16, 2020 by Roshni
• 10,520 points
0 votes

To do so, follow these steps:

  1. From the left pane of Query Editor, select the query into which you want the other query to merge. ...
  2. Select Combine > Merge Queries from the Home tab on the ribbon. ...
  3. Select State from the RetirementStats table, then select the StateCodes query. ...
  4. Select OK.

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,890 points

Related Questions In Power BI

0 votes
1 answer

How to show visualization (map) based on latitude and longitude points in power BI?

Follow the below steps: 1. Select the map ...READ MORE

answered Oct 18, 2019 in Power BI by anonymous
• 3,450 points
2,973 views
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,890 points
4,694 views
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
2,790 views
0 votes
1 answer

How to sum a data table in Power BI?

It's a good practice if you avoid ...READ MORE

answered May 17, 2019 in Power BI by Avantika
• 1,520 points

edited May 17, 2019 by Omkar 7,408 views
0 votes
1 answer

how to create snapshots in power BI?

Snapshots enable faster loading of specific properties. Follow ...READ MORE

answered Oct 29, 2019 in Power BI by Cherukuri
• 33,030 points
19,952 views
0 votes
1 answer

How to create a relative data slicer in Power BI?

Hi, With the relative date slicer or filter, you ...READ MORE

answered Jan 31, 2020 in Power BI by Shivani
1,841 views
0 votes
3 answers

How to add an extra column to the existing table in power bi query editor?

Click on edit queries after loading source ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,520 points
78,561 views
0 votes
1 answer

How to create a new dashboard by pinning visualizations from a report in Power BI?

Hey, I can show some steps wise steps ...READ MORE

answered Feb 6, 2020 in Power BI by Gitika
• 65,890 points
1,024 views
0 votes
4 answers

How to combine multiple tables in power BI?

Click Advanced Editor and check if step #"Appended ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,520 points
73,007 views
0 votes
1 answer

How to create action button in Power BI?

Hi Raghav, Follow the below steps: 1. Click on ...READ MORE

answered Jun 20, 2019 in Power BI by Cherukuri
• 33,030 points
26,904 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP