Abbreviate People Last Name

[urayz]

My data have column that contains people names and I want to abbreviate the last name of these people names.

For Example: My Name Uray Zulfikar --> the result will be Uray Z

Any recomendations DAX Formula or M Formula??

Thank you in advance!

[Anonymous · Accepted solution]

Hi @urayz,

What is the format of the field people names ? Does it include only first name and last name ? From the example you provided , the format seems like first name + one space + last name , and finally gets the first name and the first character of last name . If so , you can create a calculated column with the following formula to get:

1) The people name only include first name and last name ( for example: Jack Jones), you can create the below calculated column

    AbbreName =mid('Name'[Name],1,find(" ",'Name'[Name],1)+1)

 2) The people name include first name, middle name and last name ( for example: Jessie Tony Tessy ), you can create the below calculated column

AbbreName = MID('Name'[Name],1, FIND ( "@",SUBSTITUTE ( 'Name'[Name], " ","@",LEN ( 'Name'[Name] )- LEN ( SUBSTITUTE ( 'Name'[Name], " ", "" ))),1)+1)

If the above methods are not applicable in your scenario, please provide the related table structure and more sample data(exclude sensitive data).

Best Regards

Rena

[amitchandak]

In M , if only have First Name and Last Name

= Text.Start([Name],Text.PositionOf([Name]," ")+2)

[Anonymous]

This will be useful for you:

https://community.powerbi.com/t5/Desktop/Using-Substring-to-modify-column-data-Is-it-possible-in-Pow...