Lookup Start Date and End Date from another table

[ARomain]

Been looking online for ways to lookup the value between start and end dates and position and can't seem to figure it out

I have 2 tables, a 'Person' table that shows when the employee was hired and quit (however, the employee can quit and come back) and another table 'Position' which shows the position the person was in in a specified time range. 

Trying to get the format in the last output in the screenshot below and been experiementing with LOOKUP Values and can't seem to get it correct.

[vk_pbi · Accepted solution]

Hi @ARomain 

Please use Power query merge table option to merge these two tables. While merging tables, select Name and Positon start key to match the person table. Refer below images