Forum Discussion

GerbenvdHazel's avatar
GerbenvdHazel
Helper I
6 years ago

Look up value between two dates from different table

Good day, I have two tables. One with trajectories with an end date. The second table concerns relationships where persons working with a start and end date. The dates are not match exactly....
Need Help
Tips and Tricks
parry2k's avatar
parry2k
Super User
6 years ago

GerbenvdHazel is the 2nd table on 1 side of the relationship, if yes, then you can add column in 1st table like this

 

Company = RELATED ( Table2[Company] )

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

  • GerbenvdHazel's avatar
    GerbenvdHazel
    Helper I
    6 years ago

    A person can have different trajectories and different companies (history). I thougth about a between formula with datefilter and filter personal number

  • GerbenvdHazel's avatar
    GerbenvdHazel
    Helper I
    6 years ago

    A person can have different trajectories and different companies (history). I thougth about a between formula with datefilter and filter personal number

    • v-deddai1-msft's avatar
      v-deddai1-msft
      Community Support
      6 years ago

      Hi GerbenvdHazel ,

       

      You can add filter in LOOKUPVALUE function. But without sample data, it's difficult to provide a detailed formula.

      Would you please inform us more detailed information( your  data(by OneDrive for Business)) if possible? Then we will help you more correctly.

       

      Please do mask sensitive data before uploading.

       

      Thanks for your understanding and support.

       

      Best Regards,

      Dedmon Dai

      • GerbenvdHazel's avatar
        GerbenvdHazel
        Helper I
        6 years ago

        Thanks for helping. 
        I edit the post with a link to the file.

         

        Regards, Gerben