Capitalize Each Word USING DAX (Not Power query)

[ak77]

Hi All,

I have a requirement where i need to Capitalize Each Word of the column based on condition.

From above table The Calculated Name Column should use the condition if (Capitalize='Yes', Then <Capitalize Each Word> , Else <No Action>

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

[Ahmedx]

hi have you checked this solution

[ak77]

Hi yes. thanks for help.. worked perfectly.. acccepted as solution

[ribisht17]

Clearly shows the result at the bottom, do you mean ,you tried the same and it did not work ?

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series

[ribisht17]

hi @ak77 

You have multiple ways here including DAX

https://community.fabric.microsoft.com/t5/Desktop/How-to-Capitalize-only-the-Initial-letters-in-DAX/...

Regards,

Ritesh

[ak77]

@ribisht17  thanks for reply..

I have a doubt,. the link u provided has suggestions but non has the correct ones.. do u have any specific thread to refer.. please let me know

[Ahmedx]

there, my solution is just right