Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Finding First Name or Last name using DAX like @Username

Hi,  I understand that PowerBI records name of all the users who are logged into the app. I am using RLS on username  I want to develop a greeting where I greet them with their name such as:   ...
Need Help
Stachu's avatar
Stachu
Community Champion
7 years ago

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!

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

 

 

  • Stachu's avatar
    Stachu
    Community Champion
    7 years ago

    it 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!

  • aggregator3000's avatar
    aggregator3000
    Advocate II
    4 years ago

    Hi Anonymous , this is probably long ago solved however adding some value for other searchers.
    Stachu solution working well over here, but a small alteration needed on your key.
    Recommend using UserPrincipalName() instead for easier consistency
    Username() value output is a little volatile as PBI Service will revert it to [username][email], whereas desktop will display as [domain][username].