topic Regarding Power BI Function to search particular word from a column in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Regarding-Power-BI-Function-to-search-particular-word-from-a/m-p/1926878#M41797 <P>Hey Hi,<BR /><BR />I am looking for a function to search a particular word from a given column.<BR /><BR /></P><P>Currently, I am Using&nbsp;</P><P>&nbsp;</P><P><SPAN>Column_name = SWITCH(</SPAN></P><DIV><DIV><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;FALSE(),</SPAN></DIV><DIV><SPAN>ISERROR(SEARCH("Sai", PowerBI_Fact[Product])), "Sai",<BR />PowerBI_Fact[Product]<BR /><BR /></SPAN></DIV><DIV><SPAN>The current error for this function was -&nbsp; It was extracting by individual characters(Where I need to extract by exact word text).<BR /><BR /></SPAN></DIV><DIV><SPAN><SPAN>Example -&nbsp;<BR /></SPAN></SPAN><TABLE border="1"><TBODY><TR><TD><SPAN>Products</SPAN></TD><TD><SPAN>Output</SPAN></TD><TD>&nbsp;</TD></TR><TR><TD><SPAN>Mino sai&nbsp;</SPAN></TD><TD><SPAN>&nbsp; Sai&nbsp; &nbsp;</SPAN></TD><TD><SPAN>(Which is fine)</SPAN></TD></TR><TR><TD><SPAN>sai Kumar&nbsp;</SPAN></TD><TD><SPAN>&nbsp; Sai&nbsp; &nbsp;</SPAN></TD><TD><SPAN>(Which is fine)</SPAN></TD></TR><TR><TD><SPAN>isa&nbsp; </SPAN></TD><TD><SPAN>&nbsp; Sai&nbsp; &nbsp;</SPAN></TD><TD><SPAN>(There is no Sai in the text but it has all the words separately)</SPAN></TD></TR></TBODY></TABLE><SPAN><BR /><BR /></SPAN></DIV><DIV><SPAN>Any help can be appreciated.<BR /><BR />Thanks.</SPAN></DIV></DIV> Tue, 29 Jun 2021 01:50:36 GMT Sai_Kumar 2021-06-29T01:50:36Z Regarding Power BI Function to search particular word from a column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Regarding-Power-BI-Function-to-search-particular-word-from-a/m-p/1926878#M41797 <P>Hey Hi,<BR /><BR />I am looking for a function to search a particular word from a given column.<BR /><BR /></P><P>Currently, I am Using&nbsp;</P><P>&nbsp;</P><P><SPAN>Column_name = SWITCH(</SPAN></P><DIV><DIV><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;FALSE(),</SPAN></DIV><DIV><SPAN>ISERROR(SEARCH("Sai", PowerBI_Fact[Product])), "Sai",<BR />PowerBI_Fact[Product]<BR /><BR /></SPAN></DIV><DIV><SPAN>The current error for this function was -&nbsp; It was extracting by individual characters(Where I need to extract by exact word text).<BR /><BR /></SPAN></DIV><DIV><SPAN><SPAN>Example -&nbsp;<BR /></SPAN></SPAN><TABLE border="1"><TBODY><TR><TD><SPAN>Products</SPAN></TD><TD><SPAN>Output</SPAN></TD><TD>&nbsp;</TD></TR><TR><TD><SPAN>Mino sai&nbsp;</SPAN></TD><TD><SPAN>&nbsp; Sai&nbsp; &nbsp;</SPAN></TD><TD><SPAN>(Which is fine)</SPAN></TD></TR><TR><TD><SPAN>sai Kumar&nbsp;</SPAN></TD><TD><SPAN>&nbsp; Sai&nbsp; &nbsp;</SPAN></TD><TD><SPAN>(Which is fine)</SPAN></TD></TR><TR><TD><SPAN>isa&nbsp; </SPAN></TD><TD><SPAN>&nbsp; Sai&nbsp; &nbsp;</SPAN></TD><TD><SPAN>(There is no Sai in the text but it has all the words separately)</SPAN></TD></TR></TBODY></TABLE><SPAN><BR /><BR /></SPAN></DIV><DIV><SPAN>Any help can be appreciated.<BR /><BR />Thanks.</SPAN></DIV></DIV> Tue, 29 Jun 2021 01:50:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Regarding-Power-BI-Function-to-search-particular-word-from-a/m-p/1926878#M41797 Sai_Kumar 2021-06-29T01:50:36Z Re: Regarding Power BI Function to search particular word from a column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Regarding-Power-BI-Function-to-search-particular-word-from-a/m-p/1927259#M41806 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="302562" data-lia-user-login="Sai_Kumar" class="lia-mention lia-mention-user">Sai_Kumar</a> , try like</P> <P>&nbsp;</P> <P>Column_name = SWITCH(<BR />True(), SEARCH("Sai", PowerBI_Fact[Product],,0)&gt;0, "Sai",<BR />PowerBI_Fact[Product]<BR />)</P> Tue, 29 Jun 2021 06:31:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Regarding-Power-BI-Function-to-search-particular-word-from-a/m-p/1927259#M41806 amitchandak 2021-06-29T06:31:23Z