topic How to write measure to find out percentage of timesheets completed by employee for this year in DAX Commands and Tips

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

Anonymous — Thu, 09 Jul 2020 02:10:31 GMT

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.

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

lbendlin — Thu, 09 Jul 2020 22:55:37 GMT

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

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

Anonymous — Fri, 10 Jul 2020 22:35:14 GMT

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

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

sturlaws — Wed, 05 Aug 2020 20:19:36 GMT

Hi Anonymous

do you still have issues with this?

If yes, could you provide some sample data?

Cheers,
Sturla

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

Anonymous — Tue, 15 Sep 2020 21:43:41 GMT

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

Anonymous — Tue, 15 Sep 2020 21:49:59 GMT

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 9/5/2020

A Smith 9/12/2020

B Kane 8/29/2020