topic Re: How to capitalize the first letter in this situation in DAX Commands and Tips

How to capitalize the first letter in this situation

Anonymous — Wed, 20 Jul 2022 13:43:40 GMT

Hi guys,

I'm new using Power BI. I created a measure Username = username(), which returned that.

Then I changed the expression to return User: Name, but the name is lower case.

User = CONCATENATE("User: ",mid(USERNAME(),find("\",USERNAME())+1,LEN(USERNAME())))

I want the name first letter upper and the rest lower, as in the example below. How can I do it?

Thanks

Re: How to capitalize the first letter in this situation

tamerj1 — Wed, 20 Jul 2022 14:40:43 GMT

Hi Anonymous
The username is usually one word. Just to confirm because the solution could be different, is there any possibility to be one than one word?

Re: How to capitalize the first letter in this situation

tamerj1 — Wed, 20 Jul 2022 15:15:48 GMT

Anonymous
Here is a solution that works for one word user name https://www.dropbox.com/t/gG8TzH0N6tJJPJgA

Username = VAR CurrentUser = SELECTEDVALUE ( UserNames[USER] ) VAR String = SUBSTITUTE ( CurrentUser, "\", "|" ) VAR String1 = "User" VAR String2 = PATHITEM ( String, 2 ) VAR Length = LEN ( String2 ) VAR T1 = GENERATESERIES ( 1, Length, 1 ) VAR T2 = ADDCOLUMNS ( T1, "@Letter", VAR Letter = MID ( String2, [Value], 1 ) RETURN IF ( [Value] = 1, UPPER ( Letter ), Letter ) ) RETURN String1 & "\" & CONCATENATEX ( T2, [@Letter] )

Re: How to capitalize the first letter in this situation

Anonymous — Fri, 22 Jul 2022 11:31:10 GMT

Hi tamerj1,

Thank you for replying and sharing the document.

Yes, the expression "= username()" just returns one name after "\" but in lower case (in my case).

I am trying to transform this name into a Proper case.

I followed the steps you sent me, which still show lower case names, or I am missing some steps.

Re: How to capitalize the first letter in this situation

tamerj1 — Fri, 22 Jul 2022 11:40:05 GMT

Anonymous

Please share the code that ended up with

Re: How to capitalize the first letter in this situation

tamerj1 — Fri, 22 Jul 2022 12:41:48 GMT

Hi Anonymous
I tried with my USERENAME ( ) and seems to work just fine.

Re: How to capitalize the first letter in this situation

v-jianboli-msft — Thu, 04 Aug 2022 02:13:51 GMT

Hi Anonymous ,

According to your description, I modified your original DAX. Please try:

User = var _name = mid ( USERNAME (), find ( "\" , USERNAME ())+ 1 ,LEN ( USERNAME ())) var _U = UPPER(LEFT(_name,1)) var _L = LOWER(RIGHT(_name,LEN(_name)-1)) return CONCATENATE("User:",CONCATENATE(_U,_L))

Output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.