Forum Discussion
DAX equivalent to the Excel Proper function
My input data, from an import from SharePoint, contains the following i:0#.f|membership|[email protected] I know how to get the jason king part of the person's name (Mid/Left/Right etc)...
Hi Anonymous ,
In the Query Editor, go to the Transform tab, select Format, and select Capitalize Each Word.
And if you want use it in your measure then you can use below code:-
Column = VAR _lastName = MID ( [Your_string], SEARCH ( " ", [Your_string], 1, 1 ), LEN ( [Your_string] ) - 1 ) VAR _firstName = MID ( [Your_string], 1, SEARCH ( " ", [Your_string], 1, 1 ) - 1 ) RETURN UPPER ( LEFT ( _firstName, 1 ) ) & RIGHT ( _firstName, LEN ( _firstName ) - 1 ) & " " & UPPER ( LEFT ( TRIM ( _lastName ), 1 ) ) & RIGHT ( TRIM ( _lastName ), LEN ( TRIM ( _lastName ) ) - 1 )Thanks,
Samarth
Hi Anonymous ,
In the Query Editor, go to the Transform tab, select Format, and select Capitalize Each Word.
And if you want use it in your measure then you can use below code:-
Column =
VAR _lastName =
MID (
[Your_string],
SEARCH ( " ", [Your_string], 1, 1 ),
LEN ( [Your_string] ) - 1
)
VAR _firstName =
MID ( [Your_string], 1, SEARCH ( " ", [Your_string], 1, 1 ) - 1 )
RETURN
UPPER ( LEFT ( _firstName, 1 ) )
& RIGHT ( _firstName, LEN ( _firstName ) - 1 ) & " "
& UPPER ( LEFT ( TRIM ( _lastName ), 1 ) )
& RIGHT ( TRIM ( _lastName ), LEN ( TRIM ( _lastName ) ) - 1 )
Thanks,
Samarth
