DAX function to upper the first letter of each word of a text

[degranadost]

I have a column with a text, some of them are split by an space, others by a "-" and other by a "_". I want those text to have the first letter of a word as a capital letter.

For example:

I have this word, "walk-on", so as a result of the dax fucntion I want this "Walk-On"

[Ashish_Mathur]

Hi,

You should ideally do this in Power Query.  If you are OK with my suggestion, then share some sample data to work with and show the expected result.

[degranadost]

Thanks Rajen, I only needed to add the function LOWER because all the text was in capial letter. I have only one question, in your solution it says [Value], what is that?

[rajendraongole1]

Hi @degranadost -we can do it in power query editor,by duplicating the column perform Capitalized transformation as below

Snapshot:

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[rajendraongole1 · Accepted solution]

Hi @degranadost - create a calculated column:

CapitalizedText =

VAR OriginalText = [Text]

VAR Length = LEN(OriginalText)

VAR Result =

    CONCATENATEX(

        GENERATESERIES(1, Length),

        VAR CurrentChar = MID(OriginalText, [Value], 1)

        VAR PreviousChar = IF([Value] = 1, " ", MID(OriginalText, [Value] - 1, 1))

        RETURN IF(

            PreviousChar = " " || PreviousChar = "-" || PreviousChar = "_",

            UPPER(CurrentChar),

            CurrentChar

        ),

        ""

    )

RETURN Result

Hope it works

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[degranadost]

Hi Rajen: In my case all the letter are with capital letter, is like this. Sorry, I have forgot to mention this so the result value is the same.