Forum Discussion

Sambidha's avatar
Sambidha
New Member
6 years ago
Solved

Changing multiple row names

I have a table as below:  Country Cost Percentage Africa pacific region 1k 95% Asia Region 2k 96% Europe Region 3k 97% Latin America Region 4k 98%   Here i want to chan...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    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.

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

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.