The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
hi There,
I have a list of employes with a function, start date and an end date:
Pete | 01-01-2018 | 31-12-2055 | sales |
Maria | 12-03-2019 | 31-12-2055 | after sales |
Sharon | 01-01-2018 | 31-12-2020 | sales |
Mike | 15-04-2020 | 31-12-2021 | after sales |
I'm looking for the answer:
2018 | 2019 | 2020 | 2021 | 2022 | |
sales | 2 | 2 | 2 | 1 | 1 |
after sales | 1 | 2 | 2 | 1 |
How can I get this done in Power BI?
Solved! Go to Solution.
@JoseHop , Create a date table and follow the active employee code
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
@JoseHop , Create a date table and follow the active employee code
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
User | Count |
---|---|
158 | |
109 | |
96 | |
84 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |