Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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
Proud to be a Super User!
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
Proud to be a Super User!
Hi @OrthoData ,
You are welcome! A lot of my knowledge in Power Query comes from reading M is for (Data) Monkey by @KenPuls .
Nathaniel
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.