Show duplicates from different data sets

Question

Hi,&nbsp;There is a similiar post to this but not exactly what I want.&nbsp;I have two Data sets. One containing M3&amp;M4 maintenance notifications and the equipment number i.e&nbsp;&nbsp;M3&amp;M4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;M2Type&nbsp; &nbsp; &nbsp;Reasons&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Notification No.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Type&nbsp; &nbsp;Reasons&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Notification No.M3&nbsp; &nbsp; &nbsp; &nbsp;12345678abc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;######&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; M2&nbsp; &nbsp; &nbsp;12345678abc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ######M3&nbsp; &nbsp; &nbsp; &nbsp;12345677abc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ######&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;M2&nbsp; &nbsp; &nbsp;12345677abc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ######M4&nbsp; &nbsp; &nbsp; &nbsp;12345678abc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;######&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; M2&nbsp; &nbsp; &nbsp;12555555abc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ######M4&nbsp; &nbsp; &nbsp; &nbsp;12345676abc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;######&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; M2&nbsp; &nbsp; &nbsp;12444444abc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ######&nbsp;I want to create a table which shows when the reasons from M3&amp;M4 data set matches the reasons form the M2 data set. Then I want a table showing the M2 &amp; M3/M4 notification numbers and reasons.&nbsp;&nbsp;Can I create a custom column which checks for matches ?&nbsp;

teigegao · Answer

Hi&nbsp;fingalbrad&nbsp;,According to your description, my understanding is that you want to filter the data in M3&amp;M4 whose reason matches that in M2, in this scenario, we can use the following DAX query:Table = FILTER('M3&amp;M4','M3&amp;M4'[Reasons] in VALUES(M2[Reasons]))Best Regards,Teige

fingalbrad · Answer

Thank you,&nbsp;Will that only show the values from 'M3 &amp; M4'? I want to show all those that match so list M2,M3 &amp; M4 that have the same&nbsp; equipment-part number.&nbsp;

fingalbrad · Answer

Reason number sorry...not equipment-part

Forum Discussion

Show duplicates from different data sets

3 Replies

Related content

Duplicate ranking

SharePoint list showing duplicate data

Why rankx function shows duplicated rank?

Only Show Duplicates

Difference between Reference and Duplicate