cancel
Showing results for 
Search instead for 
Did you mean: 

Dataset cleaning

Vali_Balmer
New Contributor III
New Contributor III

What is the best practice for removing vacation weeks?

1 ACCEPTED SOLUTION

Peter_Baker
Moderator
Moderator

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
Moderator
Moderator

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.