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 calculated column/measure in Country table with TableA Calccolumn it should show TableA country values

Simillary I want to create a calculated column/measure in Country table with TableB Calccolumn it should show TableB country values

 

how to write DAX for 
TableA Calccolumn

TableB Calccolumn

 

 

Thanks

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] )

6 Replies

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

    • 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 

  • 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