Forum Discussion
Power Query help to extract unique values
- 3 years ago
Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26RhjELX0063Mh6apM9?e=cP00ai
I just wanted to follow up on this once more. Your solution worked great to pull unique data from 2 different columns when compared against each other. I was wondering if it's possible to pull unique data when comparing 2 columns against 2 other columns. So for example, I have this data where the date and ID is listed. One column contains the ID and the date it was submitted on the server where the submission went through, but then we have a tracking report that gets updated to the minute based on date and ID that's put in by the user. So the tracking sheet may contain inaccurate information compared to what's on the server.
Is there a way to pull out the unique ones if the ID and the date that goes with it is not found in the other 2 columns?
For example, I need it to list the date and ID from Column A & B if those 2 are not found in Column C and D. The ID may match, but the dates with them are different, so those need to be pulled. There is maybe multiple audits with the same date, but as long as that ID and the date that goes with it are in both A/B and C/D, then it's not pulled into the Unique Dates/IDs.
Basically, if the ID is in B and not in D, it pulls it the date that goes with it. If the ID is in D and not B, it pulls the date that goes with the ID in D. Hopefully that makes sense.
How different would the steps by to set this up, if it's even possible?