Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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)...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    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

amr0810's avatar
amr0810
Frequent Visitor
1 year ago

Not sure which version of Power BI was being used at the time. Lastest version November 2024, and I am sure previous one, in Power Query mode there is a transform text format function, where you can transform a text column to multiple case format, one of the is "Capitilize Each Word". Others are UPPERCASE, lowercase.