https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Search-and-match-String/m-p/991774#M12342 <P>Hi,</P><P>First you should split activity column by delimiter (, is the delimiter) and then unpivot all the results (exept Resource Name):</P><P><img /></P> Wed, 25 Mar 2020 20:41:44 GMT baghdadi62 2020-03-25T20:41:44Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Search-and-match-String/m-p/990680#M12294 <P>Hello,</P><P>I need help with creating a Matrix of matching activity.</P><P>Got 2 tables -</P><P>Tab1 BaseActivity: That has List of All Activities</P><P>Tab2 Resource Activity: List of Resource and Activity they assoiate to (please note they are seperated by ',')</P><TABLE border="1"><TBODY><TR><TD>BaseActivity</TD></TR><TR><TD>A</TD></TR><TR><TD>B</TD></TR><TR><TD>C</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Resource Name</TD><TD>Activity</TD></TR><TR><TD>Tom</TD><TD>A,C</TD></TR><TR><TD>Mary</TD><TD>A,B,C</TD></TR><TR><TD>Ani</TD><TD>C</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The ultimate Matrix should show a match something like;</P><TABLE border="1"><TBODY><TR><TD>Resource/&nbsp;Activity -&gt;/</TD><TD>A</TD><TD>B</TD><TD>C</TD></TR><TR><TD>Tom</TD><TD>Yes</TD><TD>No</TD><TD>Yes</TD></TR><TR><TD>Mary</TD><TD>Yes</TD><TD>Yes</TD><TD>Yes</TD></TR><TR><TD>Ani</TD><TD>No</TD><TD>No</TD><TD>Yes</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks in advance !</P> Wed, 25 Mar 2020 12:18:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Search-and-match-String/m-p/990680#M12294 Anonymous 2020-03-25T12:18:15Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Search-and-match-String/m-p/991774#M12342 <P>Hi,</P><P>First you should split activity column by delimiter (, is the delimiter) and then unpivot all the results (exept Resource Name):</P><P><img /></P> Wed, 25 Mar 2020 20:41:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Search-and-match-String/m-p/991774#M12342 baghdadi62 2020-03-25T20:41:44Z