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

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?