Forum Discussion
Find 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...
Hi I added your measures from the attached pbix , but for some reason it is not working correctly , my ID codes are a range of number both negative and positive values , like 346722 and -1381 , would this be why it is not working as in the example the id codes were 1 and 2 .
Hi Pandadev ,
It should have nothing to do with the value of ID. I found that the following two measures(__end_min&__start_min) must be placed in Table2, otherwise an error will be reported. Did you do this?
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.