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

Question

I have 2 tables, city table and population table, i need to join them to show report. How to do this?

Answer 1

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. 

Unlock your data potential with an affordable Power BI course fee! Enroll Now

Also Refer: How do you handle formatting issues when exporting Power BI reports to Excel or PDF, especially with large text tables? 

Comments

I even tried opening the images in a new tab.

---

Hi @There,

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

Answer 2

In Power BI Desktop you can join two tables with Merge menu item in the Query Editor, in Home tab, Under Combine, Merge 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?

How can I reduce the size of a Power BI file (PBIX) when working with large datasets?

Answer 3

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.

Also Read:

Adding weekly start date & end date to my date table based on week number?