Greeting

Create a personalized greeting for your users with this Quick Measure. Uses USERNAME function so that doesn't work so well with Publish To Web. Greeting = VAR user = USERNAME() VAR hour = HOUR...

Greeting.pbix28 KB

Other

Anonymous

Not applicable

6 years ago

Basically I would expect Power BI Pro to supply somehow the user first and last name through a DAX call or something else.

I understand what you proposed though it just would not give me what I want wthout having another table loaded with names with a reference from USERNAME().

Thanks anyway for the response.

Anonymous
Not applicable
6 years ago
Hello,

Just a quick tip. In case username is an email address (I assume typically this is the case), first name can be extracted with these two variables:

var vFirstNameDigit = SEARCH(".",USERNAME())-1

var vFirstName = LEFT(USERNAME(),vFirstNameDigit)

BR

Harri