Forum Discussion
Complex filter: "Hours per week"
Hi guys,
I have a table where people book hours. However, some of the "entities" that book hours are not people, but teams comprising of more people.
I only want to filter out the people. A rule of thumb is that people book a max of 50/60 hours per week, whilst teams can book hundreds of hours per week.
Weekly example:
Johan Akerfield - 41 hours
Bob Bedroom - 32 hours
X team - 200 hours
How can i create a calculated column, where based on the average hours per week I can determine whether a row is a person or a full team?
Hi Anonymous ,
Then you will have to do a column where the total per week is accumulated. Probably use Calculate based on person and time frame.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
3 Replies
- Nathaniel_C
Community Champion
Hi Anonymous ,
IF(Average(Table[Hours])<50,"Individual","Team")
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel- Nathaniel_C
Hi Anonymous ,
Then you will have to do a column where the total per week is accumulated. Probably use Calculate based on person and time frame.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel