https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Search-for-exact-match-within-a-string-of-text/m-p/4067379#M161470 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="313" data-lia-user-login="Greg_Deckler" class="lia-mention lia-mention-user">Greg_Deckler</a>&nbsp;</P><P><img /></P><P> </P> Mon, 29 Jul 2024 15:42:45 GMT _Kelz0484 2024-07-29T15:42:45Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Search-for-exact-match-within-a-string-of-text/m-p/4067273#M161461 <P>Hi,</P><P>&nbsp;</P><P>I have 2 columns within the same table and I trying to find a DAX function that uses the value of 1 column to search the other to see if it contains the 1st as an exact match.</P><P>&nbsp;</P><P>Column 1 contains a list of fitting numbers.</P><P>Column 2 contains a description of the fitting and in some cases the fitting number as well.</P><P>&nbsp;</P><UL><LI>The issue I am having is that the fitting numbers are in groups ie. MW, MW1, MW2 etc etc. I have used EXACT and CONTAINSSTRING but because it finds the MW in multiple instances it tells me there is a match. I only want it to match if complete fitting number is in the description Column.</LI></UL><P>&nbsp;</P><P>Any help would be appreciated.</P> Mon, 29 Jul 2024 14:40:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Search-for-exact-match-within-a-string-of-text/m-p/4067273#M161461 _Kelz0484 2024-07-29T14:40:15Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Search-for-exact-match-within-a-string-of-text/m-p/4067327#M161466 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="782399" data-lia-user-login="_Kelz0484" class="lia-mention lia-mention-user">_Kelz0484</a>&nbsp;Can you provide some sample data posted as text to test with?</P> Mon, 29 Jul 2024 15:24:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Search-for-exact-match-within-a-string-of-text/m-p/4067327#M161466 Greg_Deckler 2024-07-29T15:24:17Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Search-for-exact-match-within-a-string-of-text/m-p/4067379#M161470 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="313" data-lia-user-login="Greg_Deckler" class="lia-mention lia-mention-user">Greg_Deckler</a>&nbsp;</P><P><img /></P><P> </P> Mon, 29 Jul 2024 15:42:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Search-for-exact-match-within-a-string-of-text/m-p/4067379#M161470 _Kelz0484 2024-07-29T15:42:45Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Search-for-exact-match-within-a-string-of-text/m-p/4067624#M161481 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="782399" data-lia-user-login="_Kelz0484" class="lia-mention lia-mention-user">_Kelz0484</a>&nbsp;</P> <P>&nbsp;</P> <P>Would a column llike this help?</P> <LI-CODE lang="markup">Result = IF( LEN( [Fitting No] ) = 0, "Mismatch", IF( CONTAINSSTRINGEXACT( [Description], [Fitting No] ), "Exact Match", "Mismatch" ) )</LI-CODE> <P>&nbsp;</P> <P><A href="https://1drv.ms/u/s!AnF6rI36HAVkhYhVaZQ71zb-UHvoBQ?e=6hekWi" target="_blank">_Kelz0484.pbix</A></P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 29 Jul 2024 18:55:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Search-for-exact-match-within-a-string-of-text/m-p/4067624#M161481 gmsamborn 2024-07-29T18:55:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Search-for-exact-match-within-a-string-of-text/m-p/4068525#M161517 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="782399" data-lia-user-login="_Kelz0484" class="lia-mention lia-mention-user">_Kelz0484</a>&nbsp;</P> <P>&nbsp;</P> <P>Please try this m code:</P> <LI-CODE lang="markup">let a = List.Contains(Text.Split([Description]," "),[Fitting No]) in if a = true then "Exact Match" else "Mismatch"</LI-CODE> <P>You can add a custom column in power query:</P> <P><img /></P> <P>Then paste the code in it:</P> <P><img /></P> <P>The result is as follow:</P> <P><img /></P> <P>&nbsp;</P> <P>Best Regards</P> <P>Zhengdong Xu<BR />If this post&nbsp;<STRONG>helps</STRONG>, then please consider&nbsp;<STRONG><EM>Accept it as the solution</EM></STRONG><EM>&nbsp;to help the other members find it more quickly.</EM></P> <P>&nbsp;</P> Tue, 30 Jul 2024 07:18:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Search-for-exact-match-within-a-string-of-text/m-p/4068525#M161517 Anonymous 2024-07-30T07:18:27Z