Forum Discussion
Transform data into new column from mixed data: from country codes to country names
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
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
2 Replies
- Ashish_Mathur
Super User
Hi,
Share some data and show the expected result.
- v-easonf-msft
Community Support
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
