Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
95 | |
80 | |
77 | |
66 |
User | Count |
---|---|
130 | |
106 | |
105 | |
86 | |
72 |