Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I have two tables and they join on the ID column.
Table 1 has ID, FIRST NAME, LAST NAME
Table 2 has ID, ADDRESS
How do I bring the address column into Table 1. I have to do this multiple times, I'm trying to create a master table within PowerBI.
Solved! Go to Solution.
Hi @nniphadk,
There are multiple ways to bring columns from one table to another, if they have a joining key. The steps below would help you to implement a merge query in query editor to and join 2 tables and bring columns together.
There are other solutions to this problem as well, such as creating relationships between tables and using DAX formulas to create calculated columns using RELATED function.
Or
You can also use LOOKUPVALUE DAX formula as well to bring values to the table.
Use whatever suits your requirements!
Proud to be a Super User! Regards, Bipin Lala | Business Intelligence Developer | |
pls provide some sample data and expected output
Proud to be a Super User!
Hi @nniphadk,
There are multiple ways to bring columns from one table to another, if they have a joining key. The steps below would help you to implement a merge query in query editor to and join 2 tables and bring columns together.
There are other solutions to this problem as well, such as creating relationships between tables and using DAX formulas to create calculated columns using RELATED function.
Or
You can also use LOOKUPVALUE DAX formula as well to bring values to the table.
Use whatever suits your requirements!
Proud to be a Super User! Regards, Bipin Lala | Business Intelligence Developer | |