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] )
VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

HI Anonymous 

 

You can create those 2 columns with RELATED dax formula if there is a relashionship between those columns or use LOOKUPVALUE dax formula.

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi VahidDM 

     

    Thanks for your 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