Forum Discussion
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....
Hi GerbenvdHazel ,
Depending on your data, the LOOKUP function would let you use the Personal Number from the first table to lookup the Personal Number on the Second table then return the value of the Company from the matching row on the second table to the first table.
https://www.wallstreetmojo.com/power-bi-lookupvalue/
https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
explains how it works.
Hopefully this helps answer your question,
Cheers,
Richard