https://community.fabric.microsoft.com/t5/Developer/Trim-function/m-p/1855553#M29524 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/261106">@DeeMag</a>&nbsp;,</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="v-lionel-msft_1-1621564617368.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/518787iA53F83BC991EBD58/image-size/medium?v=v2&amp;px=400" role="button" title="v-lionel-msft_1-1621564617368.png" alt="v-lionel-msft_1-1621564617368.png" /></span></P> <P>Is it like this?</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="v-lionel-msft_2-1621564666211.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/518789i5D30F3044A3AF6A8/image-size/medium?v=v2&amp;px=400" role="button" title="v-lionel-msft_2-1621564666211.png" alt="v-lionel-msft_2-1621564666211.png" /></span></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><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DeeMag_0-1621376215214.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/516812i01DBB3CB08DEAABD/image-size/medium?v=v2&amp;px=400" role="button" title="DeeMag_0-1621376215214.png" alt="DeeMag_0-1621376215214.png" /></span></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="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/261106">@DeeMag</a>&nbsp;,</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="v-lionel-msft_1-1621564617368.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/518787iA53F83BC991EBD58/image-size/medium?v=v2&amp;px=400" role="button" title="v-lionel-msft_1-1621564617368.png" alt="v-lionel-msft_1-1621564617368.png" /></span></P> <P>Is it like this?</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="v-lionel-msft_2-1621564666211.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/518789i5D30F3044A3AF6A8/image-size/medium?v=v2&amp;px=400" role="button" title="v-lionel-msft_2-1621564666211.png" alt="v-lionel-msft_2-1621564666211.png" /></span></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