https://community.fabric.microsoft.com/t5/Developer/Word-string-in-Power-BI/m-p/2180275#M32816 <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/324281">@analitika123</a>&nbsp;</P> <P>Space also will be considered as string in Length</P> Tue, 09 Nov 2021 10:52:07 GMT VijayP 2021-11-09T10:52:07Z https://community.fabric.microsoft.com/t5/Developer/Word-string-in-Power-BI/m-p/2177387#M32786 <P>Hello,</P><P>&nbsp;</P><P>I have a case when word "name" and "name&nbsp; &nbsp; &nbsp;" has the same lenght of characters even it has more white spaces in the word. Therefore it shows that both words are duplicates are same despite the different number of characters.</P> Mon, 08 Nov 2021 08:07:52 GMT https://community.fabric.microsoft.com/t5/Developer/Word-string-in-Power-BI/m-p/2177387#M32786 analitika123 2021-11-08T08:07:52Z https://community.fabric.microsoft.com/t5/Developer/Word-string-in-Power-BI/m-p/2180275#M32816 <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/324281">@analitika123</a>&nbsp;</P> <P>Space also will be considered as string in Length</P> Tue, 09 Nov 2021 10:52:07 GMT https://community.fabric.microsoft.com/t5/Developer/Word-string-in-Power-BI/m-p/2180275#M32816 VijayP 2021-11-09T10:52:07Z https://community.fabric.microsoft.com/t5/Developer/Word-string-in-Power-BI/m-p/2184549#M32858 <P>You can remove the space character in the query editor:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Vlianlmsft_1-1636613307125.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/629480i088BDF8700B49890/image-size/medium?v=v2&amp;px=400" role="button" title="Vlianlmsft_1-1636613307125.png" alt="Vlianlmsft_1-1636613307125.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Vlianlmsft_2-1636613325140.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/629481i351B4F68BF9C94CB/image-size/medium?v=v2&amp;px=400" role="button" title="Vlianlmsft_2-1636613325140.png" alt="Vlianlmsft_2-1636613325140.png" /></span></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Vlianlmsft_0-1636613286599.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/629479i88CDC7748360AFED/image-size/medium?v=v2&amp;px=400" role="button" title="Vlianlmsft_0-1636613286599.png" alt="Vlianlmsft_0-1636613286599.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Vlianlmsft_3-1636613346339.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/629483i612913A471C44407/image-size/medium?v=v2&amp;px=400" role="button" title="Vlianlmsft_3-1636613346339.png" alt="Vlianlmsft_3-1636613346339.png" /></span></P> <P>&nbsp;</P> Thu, 11 Nov 2021 06:49:13 GMT https://community.fabric.microsoft.com/t5/Developer/Word-string-in-Power-BI/m-p/2184549#M32858 V-lianl-msft 2021-11-11T06:49:13Z