I've been asked to build out a card that shows employee count by month, this seems easy enough until you try and factor in the termination date.
What is expected is to show in each month the total active employees, so if employee A is hired on Jan 1st and terminated Feb 15th he would show as a count of 1 in January and a count of 0 in Feb. and then being able to sum or count the total employees active in that month.
I can start this as of the beginning of this year so could filter out all employees with a terminationdate prior to Jan 1st which could give me a starting value for January and then add in all employees with a Month(Hiredate) =1 and Termination date is null, but not exactly sure how to keep this going from month to month.
Pretty sure somebody must have run across this before, any help will be appreciated.
Thanks
Randy