Forum Discussion
Finding First Name or Last name using DAX like @Username
USERNAME() has the domain as a prefix, do you account for that in your table?
https://docs.microsoft.com/en-us/dax/username-function-dax
you can also try with USERPRINCIPALNAME()
https://dax.guide/userprincipalname/
Proud to be a Datanaut!
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
Did I answer your question? Mark my post as a solution!
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!