Forum Discussion

Pandadev's avatar
Pandadev
Post Prodigy
5 years ago

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...
Need Help
  • Pandadev's avatar
    Pandadev
    Post Prodigy
    5 years ago

    Hi 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

  • Pandadev's avatar
    Pandadev
    Post Prodigy
    5 years ago

    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 .

    • v-lionel-msft's avatar
      v-lionel-msft
      Community Support
      5 years ago

      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.