Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

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? 

  • Anonymous 

     

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

     

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

1 Reply

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion

    Anonymous 

     

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

     

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