cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
j_w
Helper IV
Helper IV

How to convert text to Title Case/Proper Case/CamelCase

 

For example, how to convert following column values:

 

Column1

an apple

TWO BIG BARS

 

into:

 

Column1

An Apple

Two Big Bars

 

Thanks

 

1 ACCEPTED SOLUTION

In the Query Editor, go to the Transform tab, select Format, and select Capitalize Each Word.

View solution in original post

1 REPLY 1

In the Query Editor, go to the Transform tab, select Format, and select Capitalize Each Word.

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 25

Ted's Dev Camp - August 25, 2022

Watch Session 25 of Ted's Dev Camp.

Top Solution Authors