Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

New Column based on values from a different table

Hi all,  I have a table with customer ID and postcode they live in (table A) and another table with postcodes and regions (Table B). I would like to create a column in table A with the Region relate...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Anonymous ,

     

    If the postcode column has unique vaule in the table B, the lookupvalue should work fine as following calculate column

     

    Region = LOOKUPVALUE('Table B'[regions],'Table B'[postcode],[postcode])

    If one postcode has multi region, you can give me the expected result based on my sample data.

     

     

    BTW, pbix as attached.

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Anonymous ,

 

If the postcode column has unique vaule in the table B, the lookupvalue should work fine as following calculate column

 

Region = LOOKUPVALUE('Table B'[regions],'Table B'[postcode],[postcode])

If one postcode has multi region, you can give me the expected result based on my sample data.

 

 

BTW, pbix as attached.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.