Need help with headcount transition between companies

[Anonymous]

Ho all,

fairly new to PBI, so scratching my head how to approach the following.

I have list of employees, with employees statistics - i.e. date of hire, date when left and transtion date (whenever employee changed position, department or company inside of a group). For each employee I have a unique id code, and for each employee moevement within the group we have a separate line in excel datasource.  See example below:

Company	Employee code	Employee name	Employee last name	Hire date	Last date	Transition date	Transition ID
A	112	John	Doe	1/12020
A	112	John	Doe			1/12/2021	1001
A	112	John	Doe			6/30/2021	1002
A	112	John	Doe		5/16/2023
B	112	John	Doe			1/12/2021	2002
B	112	John	Doe			6/30/2021	2001

We also have a separate table for movement IDs

Transition ID	Transition reason
1001	moved out company A
1002	moved in company A
1003	moved to part-time
1004	moved between departments
2001	moved out company B
2002	moved in company B
2003	moved to part-time
2004	moved between departments

[Anonymous]

List of employees is connected with automatic calendar, and table with transition IDs in PBI.

Calendar and list of employees have indirect connections.

Q: how to create a mesaure to reflect quanity of total headcount and quantity of headcount that was transitioned in a given period?

For a regular measure, when I need to count headcount based on hire and last date, I have the following: 

Count of employees = COUNTROWS ( VALUES ( Employees_Total[Employee key]))

Headcount = CALCULATE([Count of employees], filter(Employees_Total, (Employees_Total[Employment date]<= MAX('Calendar'[Date]) && Employees_Total[Termination date] > MAX('Calendar'[Date]) || (Employees_Total[Employment date]<= MAX('Calendar'[Date]) && isblank(Employees_Total[Termination date])))))

but these measures do not include any transaitions between companies nad dates of those transitions