Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Help with Dates

Greetings everyone,   I have a list on the sharepoint where people put their time working during the day.   Basically, the database looks like this:   Timesheet Date Hours Resource Activ...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello parry2k 

 

In the perfect world, the resources should enter their hours in the Timesheet every day. But that doesn't always happen, sometimes the resource forgets doing the time tracking.

 

What I would like to have is a control of how many hours should have been entered, and how many hours were actually entered. So I can see the % of adherence to the system ... as well as the amount of overtime.

 

Basically: if I have 3 resources, in 1 business week they should work 8 hours per day. That is 3x8x5 = 120 hours

 

However, the catch is that some resources work 8 hours a day, while other resources work 6 hours. That's why I have the TabResource

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

First, you can create one calendar table if it still not be created. Then create one measure as below to calculate the hours per date:

Hours per day = 
SUM ( 'TabResources'[Hours per day] )
    * CALCULATE (
        COUNTROWS ( 'Calendar' ),
        DATESBETWEEN (
            'Calendar'[Date],
            MIN ( 'Timesheet'[Date] ),
            MAX ( 'Timesheet'[Date] )
        ),
        WEEKDAY ( 'Calendar'[Date], 2 ) < 6
    )

Best Regards

Rena

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello, Anonymous 

     

    The problem is that this Hours per Day is showing me the sum of all Resources. The ideal would be to have the filter when you have a resource selected.

     

    Or am I doing something wrong?