Changing multiple row names

Hi Sambidha ,

You can try to create a calculated column like so:

Column =
VAR LastWord =
    TRIM (
        RIGHT (
            SUBSTITUTE ( [Country], " ", REPT ( " ", LEN ( [Country] ) ) ),
            LEN ( [Country] )
        )
    )
RETURN
    UPPER ( LEFT ( [Country], 2 ) & LEFT ( LastWord, 1 ) )

Best regards

Icey

If this post helps,then consider Accepting it as the solution to help other members find it faster.