User name only required

[Aruna_ln]

Hi All,

I need User Name only not compnay user account

example:My name is Aruna.don ( i am expecting this)

i am created measure USERPRINCIPALNAME() --its given total employ account(aruna.don@xxxxx.com

USERNAME()--its display my employee id

But i need only aruna.don 

Thanks

Aruna

[Anonymous · Accepted solution]

@Aruna_ln

Hello Aruna,

https://community.powerbi.com/t5/Desktop/Removing-text-after-character-or-between-characters/td-p/18...

Looking at @MFelix Formula:

Name = LEFT(USERPRINCIPALNAME(),SEARCH("@",USERPRINCIPALNAME(),1, LEN(USERPRINCIPALNAME()))-1) 

Try this.