How to create a column from one table to another table

[ramshoney1225]

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

[Jihwan_Kim · Accepted solution]

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

[ramshoney1225]

Hi @Jihwan_Kim 

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

[VahidDM]

HI @ramshoney1225 

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

[ramshoney1225]

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 

[amitchandak]

@ramshoney1225 ,

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

[ramshoney1225]

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