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.
I have a table "Employee" which lists all employees, hire date, termination date, etc. Is there a way to calculate a table from the Employee table which lists each month's end date and a calculated count of active employees for that month, where:
I've successfully used a measure to display the data this way on a bar chart by month, but in order to make some other measures and columns work, I need to have the data in the requested structure.
Does anyone have any ideas how to do this?
Thanks!
Solved! Go to Solution.
@StaceyLGriffeth , You can measure in a blog or file attached and Hire date in blank
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...
@StaceyLGriffeth , You can measure in a blog or file attached and Hire date in blank
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...
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 |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |