The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 | |