Dataset cleaning

Vali_Balmer
New Contributor
New Contributor

What is the best practice for removing vacation weeks?

1 ACCEPTED SOLUTION

Peter_Baker
Valued Contributor II
Valued Contributor II

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.

View solution in original post

1 REPLY 1

Peter_Baker
Valued Contributor II
Valued Contributor II

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.