Need help with Calculated column

[Anonymous]

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!

[Anonymous]

This is the issue with my solution (Blanks)

[css207]

Try this function.
NATURALLEFTOUTERJOIN(<LeftTable>, <RightTable>)
https://learn.microsoft.com/zh-cn/dax/naturalleftouterjoin-function-dax

[Anonymous]

This won't filter the department by Dates