Evaluate Headcount Table (SCD type II) for Trending Headcount

Hi Team,    Here's a snippet of three tables I have, one is a basic calendar table, with date, endofweek, and endofmonth and the second on is a employee table that's a slow changing dimension type ...