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 in Power BI by nithin
58 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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.

answered Mar 1 by CHERUKURI
• 13,940 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
• 830 points
21 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 in Power BI by Avantika
• 1,220 points

edited May 17 by Omkar 25 views
0 votes
1 answer

Is there a way to convert JSON data to readable table in power bi

Follow these steps step 1 - Click on ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 14,080 points
1,134 views
0 votes
1 answer

To create link visual in Power BI

You can disable sandboxing by adding this ...READ MORE

answered Nov 21, 2018 in Power BI by Upasana
• 7,680 points
30 views
0 votes
1 answer

How do you create visualizations in Power BI?

Visualizations in Power BI Visuals are the end-result ...READ MORE

answered Feb 27 in Power BI by Phalguni
• 830 points
26 views
0 votes
1 answer

How do you add a slicer from different table in Power BI?

In order to add a slicer from ...READ MORE

answered Mar 5 in Power BI by Phalguni
• 830 points
24 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
• 13,940 points
335 views
0 votes
1 answer

How do you create a link visual in Power BI?

You can easily create a link between ...READ MORE

answered Mar 8 in Power BI by Avantika
• 1,220 points

edited Mar 9 by Avantika 36 views
0 votes
1 answer

How to combine multiple tables in power BI?

Hi Sindhu, You can merge the 3 tables ...READ MORE

answered Mar 14 in Power BI by CHERUKURI
• 13,940 points
54 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
• 13,940 points
17 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.