https://community.fabric.microsoft.com/t5/Developer/Trim-function/m-p/1855553#M29524 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="261106" data-lia-user-login="DeeMag" class="lia-mention lia-mention-user">DeeMag</a>&nbsp;,</P> <P>&nbsp;</P> <P><img /></P> <P>Is it like this?</P> <P><img /></P> <P><A href="https://docs.microsoft.com/en-us/dax/trim-function-dax" target="_blank">TRIM function (DAX) - DAX | Microsoft Docs</A></P> <P>Your space is between the words(double quotes), so it is not removed.</P> <P>&nbsp;</P> <P>Best regards,<BR />Lionel Chen</P> <P>If this post<SPAN>&nbsp;</SPAN><STRONG><I>helps</I></STRONG>, then please consider<SPAN>&nbsp;</SPAN><STRONG><I>Accept it as the solution</I></STRONG><SPAN>&nbsp;</SPAN>to help the other members find it more quickly.</P> <P>&nbsp;</P> Fri, 21 May 2021 02:40:41 GMT v-lionel-msft 2021-05-21T02:40:41Z https://community.fabric.microsoft.com/t5/Developer/Trim-function/m-p/1849680#M29477 <P>Hi,</P><P>&nbsp;</P><P>can you please help me in trimming this space please. I have used Trim function on this text field but the Trim function does not work on this.</P><P>The length of this reference is showing as 12 instead of 11.&nbsp; There is space before the reference number.</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>Thank you.</P> Tue, 18 May 2021 22:19:17 GMT https://community.fabric.microsoft.com/t5/Developer/Trim-function/m-p/1849680#M29477 DeeMag 2021-05-18T22:19:17Z https://community.fabric.microsoft.com/t5/Developer/Trim-function/m-p/1855553#M29524 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="261106" data-lia-user-login="DeeMag" class="lia-mention lia-mention-user">DeeMag</a>&nbsp;,</P> <P>&nbsp;</P> <P><img /></P> <P>Is it like this?</P> <P><img /></P> <P><A href="https://docs.microsoft.com/en-us/dax/trim-function-dax" target="_blank">TRIM function (DAX) - DAX | Microsoft Docs</A></P> <P>Your space is between the words(double quotes), so it is not removed.</P> <P>&nbsp;</P> <P>Best regards,<BR />Lionel Chen</P> <P>If this post<SPAN>&nbsp;</SPAN><STRONG><I>helps</I></STRONG>, then please consider<SPAN>&nbsp;</SPAN><STRONG><I>Accept it as the solution</I></STRONG><SPAN>&nbsp;</SPAN>to help the other members find it more quickly.</P> <P>&nbsp;</P> Fri, 21 May 2021 02:40:41 GMT https://community.fabric.microsoft.com/t5/Developer/Trim-function/m-p/1855553#M29524 v-lionel-msft 2021-05-21T02:40:41Z