How to count active employees per month by hired and term date
I have a table that provides employee ID, their hired date and term date. By using hired and term date, i need to display how many team members were active per month.
For example, row 2-4 will be considered as active employees as of January 2021 and row 5-8 will be considered as active employees as of Feb 2021. I am unsure I should create this into dax. Appreciate your help!