Obtain Values from dim table in Many to Many relationship based on date value in Fact table

Hi There,

I have a task which I need to accomplish for my work purposes. I have two table Fact and Employee info Table. The task is to get the Dept and Cost Cost on Based on Date of Examine. In words, Fact table would look into Dim Table to see an employee in Dim Table with matching ID, Filter whole table just for that employee and then based on Date of examining would return value for Dept and Cost.

Thanks in Advance!

For example, in below Fact table, Values should be as per below: