Forum Discussion
Merge 2 datasets by common id field AND 2 dates if they are within 365 days of each other
Hi, I have 2 datasets that I would like to merge together. There is a common id field between the two but I need the two datasets to also align by date. There is no common date field. One dataset...
LPSUCSF -
You could merge/join the tables using Power Query. While in PQ, you can than evaluate the dates then filter out any that do not met the criteria. If you could provide a data sample we could help with a more detailed solution.
ChrisMendoza Please see updated Excel file with desired merge results. I need the rows to align where the created date and completed date are with 365 days of each other. Thank you!