Forum Discussion
Help with Dates
Anonymous solution is attached, you can take it from here.
Would appreciate Kudos 🙂 if my solution helped.
Super UserAnonymous does that mean everyday each Resources hours get added regardless they worked or not? On 03rd, if R3 comes with 8 hrs per day , does that mean it will added 24 hours for 03rd (8 hours each R1, R2 and R3. Is this the business logic? Number of users x resource hours x number of dates?
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
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
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?
- parry2k
Anonymous ok if that is the business logic, it can be achieved, assuming everybody worked everyday, if only one user has entered the data , we will assume total resource x there hours per day x number of days
- parry2k
Anonymous solution is attached, you can take it from here.
Would appreciate Kudos 🙂 if my solution helped.