topic Re: extract string from values with different len in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/extract-string-from-values-with-different-len/m-p/4018396#M158481 <P><img /></P><P>Pls check the solution.</P> Mon, 01 Jul 2024 11:10:31 GMT Anonymous 2024-07-01T11:10:31Z extract string from values with different len https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/extract-string-from-values-with-different-len/m-p/4018257#M158465 <P>Hi, I have several Store[point of sale] column values that are compound names, where there is a code and then the actual point of sale name. For example.</P><P><EM>123 Ltd. Sea</EM><BR /><EM>234 srlsl Montagna</EM><BR /><EM>23456 asd Lake</EM></P><P>I just want to have the store names Sea, Montagna, Lake appear in a barplot. How do I extract them? Thank you very much</P> Mon, 01 Jul 2024 09:19:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/extract-string-from-values-with-different-len/m-p/4018257#M158465 Anonymous 2024-07-01T09:19:23Z Re: extract string from values with different len https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/extract-string-from-values-with-different-len/m-p/4018352#M158476 <P>Anonymous</LI-USER>&nbsp;, You can achieve this using DAX and creating a new calculated column</P> <P>&nbsp;</P> <DIV> <DIV><SPAN>StoreName </SPAN><SPAN>=</SPAN></DIV> <DIV><SPAN>&nbsp; &nbsp; &nbsp;VAR StoreText </SPAN><SPAN>=</SPAN> <SPAN>'YourTableName'</SPAN><SPAN>[Store]</SPAN></DIV> <DIV><SPAN>&nbsp; &nbsp; &nbsp;VAR SpacePosition </SPAN><SPAN>=</SPAN> <SPAN>FIND</SPAN><SPAN>(</SPAN><SPAN>" "</SPAN><SPAN>, StoreText, </SPAN><SPAN>1</SPAN><SPAN>, </SPAN><SPAN>LEN</SPAN><SPAN>(StoreText))</SPAN></DIV> <DIV><SPAN>&nbsp; &nbsp; &nbsp;RETURN </SPAN><SPAN>MID</SPAN><SPAN>(StoreText, SpacePosition </SPAN><SPAN>+</SPAN> <SPAN>1</SPAN><SPAN>, </SPAN><SPAN>LEN</SPAN><SPAN>(StoreText) </SPAN><SPAN>-</SPAN><SPAN> SpacePosition)</SPAN></DIV> <DIV>&nbsp;</DIV> <DIV><SPAN>I have also attached PBIX file with sample data</SPAN></DIV> </DIV> Mon, 01 Jul 2024 10:31:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/extract-string-from-values-with-different-len/m-p/4018352#M158476 bhanu_gautam 2024-07-01T10:31:53Z Re: extract string from values with different len https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/extract-string-from-values-with-different-len/m-p/4018396#M158481 <P><img /></P><P>Pls check the solution.</P> Mon, 01 Jul 2024 11:10:31 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/extract-string-from-values-with-different-len/m-p/4018396#M158481 Anonymous 2024-07-01T11:10:31Z Re: extract string from values with different len https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/extract-string-from-values-with-different-len/m-p/4024689#M158867 <P>thank you, both works</P> Thu, 04 Jul 2024 09:11:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/extract-string-from-values-with-different-len/m-p/4024689#M158867 Anonymous 2024-07-04T09:11:12Z