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
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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Tried it, but I am getting an error saying that the region field is not recognised as there is no relationship between the two tables, even thoug hI created the relationship already. 

    Is there anything iam missing?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi,

      Can you share your report pbix?

      Thanks.