Forum Discussion

lekkerbek's avatar
lekkerbek
Helper IV
5 years ago

Calculate productivity

Hi,

 

I have a table with basic information about staff. 

* EmployeeID

* Name

* Contract hours per week

 

I have another table with information on staff working on various jobs and time spent (in minutes):

* EmployeeID

* Name

* Date

* Customer

* Articlenumber

* Number of minutes

 

And of course a date table.

 

I would like to calculate the productivity of the staff of a given month. In the Staff table I added a column where I added the maximum number of hours on an annual basis, basically:

 

contracthours / 40 (maximum hours per week) * 2.080 (maximum hours on an annual basis).

 

I would like to create a report with a slicer per month where I can quickly show the productivity.

 

actual time spent / maximum hours per month. 

 

Is there a simple way to do that? 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi lekkerbek ,

     

    If i understand you correctly, contracthours should be something like below.

    contracthours = calculated(sum(number of minutes),filter(allexcetp(table2,employeeid),format('table2'[date],"YYYYMM")=selectedvalue('date'[yearmonth])))

    It would be better to share some sample data and the expected result to us so that we can check if the formula is what you need.

     

    Best Regards,

    Jay