Forum Discussion
Solved
USERPRINCIPALNAME() to Display Name
Hi, I'm trying out the USERPRINCIPALNAME() function. So it displays the email address which is expected. I have a dataset that has two columns, Name and Email Address. But in this case, sinc...
Nevermind I managed to resolve it based on this thread: Solved: How to display Username with greetings when user ... - Microsoft Power BI Community
This is the code I used to achieve my initial problem:Display Name = VAR user = USERNAME() VAR display = LOOKUPVALUE(Table1[User],Table1[Email],user) RETURN(display)
Nevermind I managed to resolve it based on this thread: Solved: How to display Username with greetings when user ... - Microsoft Power BI Community
This is the code I used to achieve my initial problem:
Display Name =
VAR user = USERNAME()
VAR display = LOOKUPVALUE(Table1[User],Table1[Email],user)
RETURN(display)