Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to create a column from one table to another table

Hi  I need to fullfuil the below requirement,  I have country table with countries I have tableA with country as foreign key  I have tableB with country as foreign key   Now i want to create a ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I am not sure if I understood your question correctly, but please check the below picture and the attached sample pbix file.

     

    TableA CC =
    IF( Country[Country] in VALUES(TableA[Country]), Country[Country] )
     
    TableB CC =
    IF( Country[Country] in VALUES(TableB[Country]), Country[Country] )
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi amitchandak 

 

Thanks for the support, ya i have though of using RELATED , but my case is differnt I need to create that column in primary key table.

RELATED i'm able to get the single values in to "TableA" but I'm not able to write a DAX in to Country table