View My Drafts
I had a similar scenario, here is the measure I created that works for me. I do have a calendar table, but it's not linked to the HRTable. It looks like this:
Head Count =
how do i get Opening headcount for Month and closing headcount of month by Join date and exit date
i have created calendar auto for dates creating a relation between join date and exit date.
It will be helpful if i get opening fiscal year headcount and closing year headcount as well where fiscal year starts from April and ends in March.
Have created a dax as below currently but the count seems to be wrong