Forum Discussion
Dataset cleaning
What is the best practice for removing vacation weeks?
There are two common methods for removing low collaboration (holiday) weeks: 1. Filter out low collaboration weeks within Power BI based on a strict threshold. For example, set filter criteria to exclude all employee weeks where emails sent < 5. 2. Create a calculated field that flags when an employee's collaboration is at least 1.5 standard deviations below their average collaboration over a given time period. Filter out employee weeks that fall below this individualized threshold.
1 Reply
There are two common methods for removing low collaboration (holiday) weeks: 1. Filter out low collaboration weeks within Power BI based on a strict threshold. For example, set filter criteria to exclude all employee weeks where emails sent < 5. 2. Create a calculated field that flags when an employee's collaboration is at least 1.5 standard deviations below their average collaboration over a given time period. Filter out employee weeks that fall below this individualized threshold.