Forum Discussion
Active Employees per Period
Thank you for the advice. I tried it and do not get the correct result, either. What I do get is the number of employees, who left in a specific period (e.g. month).
As I have to deliver the report today, I resolved to take a different approach, showing the number of joiners, leavers and overall evolution of active personnel as in the chart below.
I don't think you can use the Active Status here as that one probably only works for the current Employees as of today right?
If you want historic "Active Employees" in a past month they need to have >= Contract Start and <= Contract End within that month.
Thank you. Yes, I think so, too and tried to do so. But so far without success. Any proposal, how the DAX would look like for this, would be much appreciated.
Not sure how this can be solved just by DAX.
I suggest you do a second Date Table joined on Contract End then you have Startdate and Enddate and then you can filter EndMonth <=