Need help with Calculated column

Hi Users,
I'm working on a report with a complex large dataset. Because I cannot reveal the data here, so instead I'm sharing a sample data with the same issue which I'm trying to solve. Below I've attached two images of corresponding two tables - one has employee attributes and the other has the department to which he/she belongs. I want to bring the department data Datewise in the 1st table. How should I do that? Currently, I'm using IFERROR(CALCULATE(LOOKUPVALUE(), date filters ), blank())

But I'm getting blanks for employees with multiple departments even when I have given date slicers (as LOOKUP gives error in many-to-many relations). amitchandak Greg_Deckler 

Please help!