Hi @robertdseals ,
Just quick answer (currently totaly lack of time) - you sad that your date table doesn’t show all the dates - beside fact table that you use HireEmployeeRecord your Dim_Date have or have not continous date dimension (all dates - not just thoose that you have in fact table) ?
Melissa made such great explanation in serial of posts about Time intelligence + provide code for continous Date dimension
Also quick pick from Enteprise DNA learning stack
in DAX Formula Pattern you can check
- Events in progress
- Cumulative Totals serials:
Hope it helps.