Look up column value from a different table based on unique key

[Anonymous]

I have table 1 with a unique key called [Member ID]

Table 1 does not include [Country]

Table 2 has [Member ID] and [Country]

I want to pull the values in [Country] from table 2 into table 1 using [Member ID]

Can you help? 

[Zubair_Muhammad · Accepted solution]

@Anonymous 

Assuming the 2 tables are related by Member ID, try this column

=
CONCATENATEX ( RELATEDTABLE ( Table2 ), Table2[Country], "," )