dax query to convert first word of rows is capital.

[Shreesefwere]

here is the table

A1

sam disouza

=UPPER(LEFT(A1,SEARCH(" ",A1)-1))&PROPER(MID(A1,FIND(" ",A1),LEN(A1)))

error message unable to find 

The search Text provided to function 'FIND' could not be found in the given text.

SAME  FOR 

Failed to resolve name 'PROPER'. It is not a valid table, variable, or function name.

please note i do not want in transform data option

[Uzi2019 · Accepted solution]

Hi @Shreesefwere 

just paste below code in calculated column not measure

Column =
VAR _lastName =
MID (
'Person'[# of Person],
SEARCH ( " ", 'Person'[# of Person], 1, 1 ),
LEN ( 'Person'[# of Person] ) - 1
)
VAR _firstName =
MID ( 'Person'[# of Person], 1, SEARCH ( " ", 'Person'[# of Person], 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 )

I hope this time you may get correct answer!

[Shreesefwere]

same error

[Uzi2019]

hi @Shreesefwere 
table name must be in single quotes. you have missed the ' quotes to end table name.

check line by line my code and correct your comma issue.

[Shreesefwere]

different issue

here is the code

Column3 =

VAR _lastName =

    MID (

        Person[# of Person],

        SEARCH ( " ", Person[# of Person], 1, 1 ),

        LEN ( Person[# of Person]) - 1

    )

VAR _firstName =

    MID ( Person[# of Person], 1, SEARCH ( " ", Person[# of Person], 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 )

[Uzi2019 · Accepted solution]

Hi @Shreesefwere 

just paste below code in calculated column not measure

Column =
VAR _lastName =
MID (
'Person'[# of Person],
SEARCH ( " ", 'Person'[# of Person], 1, 1 ),
LEN ( 'Person'[# of Person] ) - 1
)
VAR _firstName =
MID ( 'Person'[# of Person], 1, SEARCH ( " ", 'Person'[# of Person], 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 )

I hope this time you may get correct answer!