Forum Discussion

Helper III

7 years ago

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

Need Help

Oomsen
7 years ago
v-diye-msft
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()))

v-diye-msft

Community Support

7 years ago

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:

https://wicren-my.sharepoint.com/:u:/g/personal/dinaye_wicren_onmicrosoft_com/EUoRzHnN7cNFlU7wMJjuQ9UBXC_Nxxq1ixh6Tq4w0kAnqg?e=nPKBKE