How to write measure to find out percentage of timesheets completed by employee for this year

[Anonymous]

We have recently implemented project time tracking for our team and would like to calculate the % of timesheets completed for each employee.  I would use the EE start date and End date from timesheet report.  How would I write this in power bi.  

If it helps I do have a DateDim sheet with Dates of year, Month, Week of Year and Year.

[lbendlin]

- set page filter to current year

- add a matrix visual

- put the employees in the rows and the completion indicator in the columns

- put the count of timesheets in the values and display values as percentage of row total

verify that that is what you wanted, then write the measure accordingly.

[Anonymous]

It shows 100% for everyone and I know by looking at our time report that there are a few people who have not done timesheets for a couple of months.  Any other suggestions??

[sturlaws]

Hi @Anonymous 

do you still have issues with this?

If yes, could you provide some sample data?

Cheers,
Sturla

[Anonymous]

Hi,  I am not sure if my previous message showed.  I was getting an error message.

I was able to figure out formula to calculate # of timesheets required to be completed.  But not able to calculate the number of timesheets each employee has completed to date.  The Time report has a field with "EE Name" and "End Date" (End date being the date timesheets are submitted (this is the same for each employee).  The one issue I see is that because our time report records each project as a separate row, the end date has many rows for each employee.  See example below

A Smith  8/29/2020

A Smith 8/29/2020

A Smith 9/5/2020

A Smith 9/5/2020

A Smith 9/12/2020

A Smith 9/12/2020

B Kane 8/29/2020

B Kane 8/29/2020