Forum Discussion
Pandadev
Post Prodigy
Post ProdigyFind Closest Matching Date based on matching ID code from 2 tables
I am trying to compare the start and end events from 2 tables , both tables are joined by a matching ID , I am trying to find the closest matching date in table table 2 for each row in table 1. Exam...
v-lionel-msft
Community Support
Community SupportHi Pandadev ,
Please refer to my .pbix file.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
PandadevPost Prodigy
Post ProdigyHi Thanks for looking at this , is it possible to adapt this to just check the start date , as I forgot that one table does not have an end date in it , thanks