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.
Hi,
I am trying to build an attrition dashboard for 2018 using an employee index with all employee's start dates & termination dates (if applicable) , this start dates go back years whereas the termination dates are from 2018 onwards.
I have got my measures for total leavers/joiner & % attrition working, however, my opening headcount is not correct.
My calender table is using employee start dates and I only have termination dates for 2018 so my opening headcount in JAN 2018 is higher than it should be.
Any suggestions would be greatly appeciated!!
Solved! Go to Solution.
Not much you can do. Bad data is bad data.
Either get the proper term dates or supplement your data with a "cheat sheet" (excel data from someone who knows) to fix.
Not much you can do. Bad data is bad data.
Either get the proper term dates or supplement your data with a "cheat sheet" (excel data from someone who knows) to fix.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |