Match a pair of values from one column based on multiple other columns

[OrthoData]

I have the following structure:

Date	Object ID	Type
1/1/2019	100023	A
1/1/2019	100025	A
1/1/2019	100023	B
1/2/2019	100065	A
1/2/2019	100098	B
1/2/2019	100098	A
1/3/2019	100052	A
1/3/2019	100052	A
1/3/2019	100058	A

My goal is to have Power Query flag a Match whenever both type A and B share the same Object ID and Date.

I am interested to know if the A/B match happens multiple times for the same Date/Object ID combo. I do not need to know if only A or only B mathc multiple Date/Object ID combos. I've tried creating many variations of GroupBy tables and Calculated Columns but have not found a solution. Can someone please help with this? Thank you!

[Nathaniel_C · Accepted solution]

Hi @OrthoData ,

Created a copy of the table, filtered 1 for A and 1 for B, Merged them based on the first two columns and then expanded for the last column. From there you can throw a flag on the condition. Or you can filter out null, and end up with the values that match.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[OrthoData]

@Nathaniel_C Thank you. What a great, simple solution! 

[Nathaniel_C]

Hi @OrthoData ,
You are welcome! A lot of my knowledge in Power Query comes from reading M is for (Data) Monkey by @KenPuls .
Nathaniel