Transform data into new column from mixed data: from country codes to country names

[Talgat2050]

Hi,

In data.country column I have full Country names (like Turkey) and country codes (like TR)

Because the data comes from various sources. My task is to display only the names of countries in a new column, without country codes, i.e. Turkey's country code TR would change to Turkey- country name in the new column. I think it should be done through DAX functions.

Thank you

[v-easonf-msft · Accepted solution]

Hi, @Talgat2050 

If you have build a bidirectional relationship between two tables based on field "Country code", then you can consider using the following formula to create a calculated column.

Country Name = RELATED(Table1[Country names])

If I misunderstood, please share the sample to explain further.

Best Regards,
Community Support Team _ Eason

[Ashish_Mathur]

Hi,

Share some data and show the expected result.