DAX (or M) Function to retrieve First & Last Name

Question

Is there a DAX or M function I can use to dynamically display the First and Last Name of the logged in user?

p.s. I can't use username(), nor UserPrincipalName(), as they do not provide this info.

Example:

UserID: jd22334 <--- username()

email: [email protected] <---- UserPrincipalName()

First & Last name: John Doe <--- ???

Thanks!

olivero · Answer

HiWhat do you mean "they do not provide this info"?How do they login to the service?

olivero · Answer

I think I know what you meaneg they login as jsmith@blah.comcan you have a table of usernames, first names and surnames?egjsmith | John | Smith&nbsp;and just do a lookup?

richflorida · Answer

OliverO&nbsp;I mean they provide userID and email address of logged user, not the First and Last Name!!!&nbsp;Example:First &amp; Last name: John DoeUserID: jd22334&nbsp; &nbsp; &nbsp; &nbsp;&lt;---&nbsp;username()email: jd22334@domain.com&nbsp; &lt;----&nbsp;UserPrincipalName()

olivero · Answer

coolSo can you create a table likeUser id&nbsp; &nbsp; FirstName&nbsp; &nbsp; Surnamejd22334&nbsp; John&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Doebb1123&nbsp; &nbsp;Bugs&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Bunnymm123&nbsp; &nbsp;Mickey&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Mouse

richflorida · Answer

Hi OliverO&nbsp;&nbsp;I can't create a table, as I need to capture the name dynamically based on the currently logged in user interacting with the Dashboard.

Forum Discussion

DAX (or M) Function to retrieve First & Last Name

10 Replies

Related content

Retrieving data via HTML

Cannot retrieve Contacts from API

Retrieving deleted notebook

DATESYTD function

Retrieving Values from Single Column