Forum Discussion
Solved
Working hours until today
With the measure below i calculate the workable hours: Werkuren = IF('Medewerker uren'[Dag]=2;7,6;0)&IF('Medewerker uren'[Dag]=3;7,6;0)&IF('Medewerker uren'[Dag]=4;7,6;0)&IF('Medewerker uren'[Dag]=...
It didn't solve the problem.
But with some try and error i found the solution:
I changed my measure to :Werkuren tot vandaag = CALCULATE(SUM('Medewerker uren'[Werkuren]);FILTER(Dimdate;Dimdate[Datum]<=TODAY()))
Hi v-diye-msft
The measure is ment for counting available working hours and compare them with the actuals worked hours of employees.
I will translate it to english:
Working hours = IF('Employee hours'[Day]=2;7,6;0)&IF('Employee hours'[Day]=3;7,6;0)&IF('Employee hours'[Day]=4;7,6;0)&IF('Employee hours'[Day]=5;7,6;0)&IF('Employee hours'[Day]=6;7,6;0)
Our working days contain 7,6 hours. So what i did is count 7,6 if the day is a monday, tuesday, wednesday, thursday or friday. I display this per month and can see what the "workable" hours are per month.
I compare this with the actuals hours and report a % of worked hours witch is nog more then dividing actuals by workable hours.
But when i do this nowm, i compare actuals (correct) with all workable hours (incorrect). That is why i would like to adjust my measure so that in only count 7,6 hours a day until today.
Hi Oomsen ,
FIf my understanding is correct, you'd like to compare the standard workhours with actual workhours. your standard workday is from Monday to Friday, with 7.6 hours per day.
I created a calenday table list from 7/1 -today, then add the calculated column to specify the weekday, finally add the measure to generate the total standard workhours: results shown as below, you can find the pbix here:
Best regards,
Dina Ye
It didn't solve the problem.
But with some try and error i found the solution:
I changed my measure to :Werkuren tot vandaag = CALCULATE(SUM('Medewerker uren'[Werkuren]);FILTER(Dimdate;Dimdate[Datum]<=TODAY()))