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] )
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
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 Jihwan_Kim 

    Thanks for your support with DAX forumla.
    Its working as expected , Thank you so much.