Forum Discussion
Solved
Add column from a different table
I have 2 tables "similar" to below Table 1 ID Company Code Country City 1 50 Blah Blah 2 60 Blah Blah 3 50 Blah Blah 4 31 Blah Blah Table 2 ID Company...
Hi StuartSmith
Create an active relationship between Table 1 and Table 2 based on a common column like ID or Company Code.
Now go to your Table 1, add a new column and use below DAX;
CompanyName=RELATED(Table2[Company Name])Thanks,
Sanket.If this post helps, then mark it as "Accept as Solution" and give it a thumbs up.
Hi, how are u?
First of all you should create a relation between these tables in here:
You just need to drag "Company" from table1 to "Company" from table2.
After, if you move the information from different table in the same chart, the information will match.
Regards!