Abbreviation Solution instead of MID function

[kivanct]

Hi everyone,

In order to receive abbreviated version of United States of America, i created the formula below by using MID function.

Do you know any idea to create a short formula, instead of using what i have done below. (Maybe more efficient one)

IF (

    CONTAINSSTRING ( 'Table 4'[financials_Country], "United States" ),

    COMBINEVALUES (

        ".",

        MID ( 'Table 4'[financials_Country], 1, 1 ),

        MID ( 'Table 4'[financials_Country], 8, 1 ),

        MID ( 'Table 4'[financials_Country], 18, 1 )

    ),

Regards...

[TomMartens]

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