https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-replacing-true-to-True/m-p/1958325#M42781 <P>In Tranform Data you can right click on the column and select transorm then Capitalize Each Word</P><P><img /></P><P>&nbsp;</P> Wed, 14 Jul 2021 21:13:15 GMT Anonymous 2021-07-14T21:13:15Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-replacing-true-to-True/m-p/1958199#M42773 <P>Having trouble with a very simple issue.<BR />A boolean column has true and false in lower case, but I want to replace with proper Sentence case. i.e.</P><P>true = True<BR />false = False</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD><STRONG>ColumnA</STRONG></TD></TR><TR><TD>true</TD></TR><TR><TD>false</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Instead, I want to have:</P><TABLE border="1"><TBODY><TR><TD>ColumnA</TD></TR><TR><TD>True</TD></TR><TR><TD>False</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks</P> Wed, 14 Jul 2021 19:36:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-replacing-true-to-True/m-p/1958199#M42773 bmrizvi 2021-07-14T19:36:58Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-replacing-true-to-True/m-p/1958325#M42781 <P>In Tranform Data you can right click on the column and select transorm then Capitalize Each Word</P><P><img /></P><P>&nbsp;</P> Wed, 14 Jul 2021 21:13:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-for-replacing-true-to-True/m-p/1958325#M42781 Anonymous 2021-07-14T21:13:15Z