Forum Discussion
Finding First Name or Last name using DAX like @Username
Both functions that you have mentioned doesn't return me any family name. I am little unsure if it can actually be retrieved?
I assumed that you have some dictionary table that allows to find the name based on the USERNAME() or the other function. Is that correct?
Usernames don't have to be based on the names/surnames, so returning the id seems the logical solution here
Proud to be a Datanaut!
Okay this makes sense, so in that case, I have following columns in my dataset.
Name Companyemail John Smith [email protected] Brown Fox Given the above table, can we do that it searches for Username in company email, and if matches, display Name? If yes, what would be the dax?
what format does USERPRINCIPALNAME() return for you? I assume it would be something like [email protected]
If that's the case then this should work:HelloUser = "Hello " & CALCULATE ( FIRSTNONBLANK ( 'Table'[Name], TRUE ), 'Table'[Companyemail] = USERPRINCIPALNAME () )Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!
Thanks for helping out, however it doesn't seem to be working. It only returns "HelloUser", that's all, and yes userprincipalname returns me email such as [email protected].
Btw I am using Username for Dynamic RLS and not userpricipalname