strip out the domain name from the userprincipalname() in Manage Roles/Row level Security

[LP280388]

Hi Team,

I have a report which uses an "useremail" column and the Userprincipalname() for the Row level Security. Lately we have identified that there are users with multiple domain names. 

So, in this case we would like to strip out the domain name and take only the employeeid for the Row Level Security.

Please help me how can I modify the below DAX to remove the @domain name and take only the employee ID.

[UserEmail] = userprincipalname()

[amitchandak · Accepted solution]

@LP280388 , You need to share a format to suggest replace

Assume there /. You have try something like

[UserEmail] =  right( userprincipalname() , len(userprincipalname() ) - search("/", userprincipalname() ,,0)  )