Forum Discussion
Finding First Name or Last name using DAX like @Username
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 userpricipalnameit cannot return HelloUser beacause that's the measure name - have you added this syntax as a new measure? It's completely unrelated to RLS
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!