Forum Discussion
Employee Absence Rate
Hi, I'm trying to calculate employee sickness absence rate, the end goal is to have a graph showing the absence rate for each month which will change when a different business area is selected. T...
I'm afraid I'm unable to share the file due to the sensitivity of the data.
1. Would that be one directional from Employee Info to Working days?
2. What would I change it to?
3. What type of relationship would this be? Would this then filter all of the other matching columns?
- Since you have a Many to Many relationship Power BI is going to ask you if you want filter Employee with Working Days or vice versa.
- If you were to keep your model the way you have it, then you would need other tables that had no duplicates. For instance, if you were joining on Employee ID between two tables then you would want a list of all distinct Employee IDs between those two tables.
- Employee ID to Emp ID? I assume they are the same? As for the other tables I would use your Sickness Absence as your Fact table connecting Employee to it. Connecting the Working Days table to the Sickness Absence and Sector to Employee.