Abbreviation Solution instead of MID function

Hey kivanct ,

first, I have no better idea.
But instead using DAX I would recommend creating a mapping table (maybe based on Excel), with two columns like financials_country and country_short
Then I would use Power Query's Merge function to merge both tables and get the new column into Table4, as it is a left join cells of this new column might be empty because values are not contained in the mapping table. Finally I would create a new column (also with Power Query) that checks if the first new column is null, in this case take the original country name other wise the value from the new column 1.

Hopefully this provides an idea of how to tackle this challenge.

Regards,
Tom