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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

You will need to join the two tables using postcode field and use below dax to create a calculated column in Table A to get the region field from Table B.

Region = RELATED( Table B[Region] )

Thanks.