Trying to follow Calculating Staff Turnover In Power BI Using DAX

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.