cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Oomsen Regular Visitor
Regular Visitor

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]=5;7,6;0)&IF('Medewerker uren'[Dag]=6;7,6;0)
 
I would like to adjust the measure or create a new one to exclude al hours after today.
1 ACCEPTED SOLUTION

Accepted Solutions
Oomsen Regular Visitor
Regular Visitor

Re: Working hours until today

@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()))
 
 
4 REPLIES 4
Community Support Team
Community Support Team

Re: Working hours until today

Hi @Oomsen 

 

Could you please specify the meaning of your formula? I can barely understand it. It’s preferred to share us your detailed data (upload your pbix to Onedrive and share links here) but kindly masking your confidential info.

 

We’d like to provide further support once we got it.

 

Best regards,

Dina Ye

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Oomsen Regular Visitor
Regular Visitor

Re: Working hours until 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.
 
 
Community Support Team
Community Support Team

Re: Working hours 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: 

https://wicren-my.sharepoint.com/:u:/g/personal/dinaye_wicren_onmicrosoft_com/EUoRzHnN7cNFlU7wMJjuQ9...

Capture.PNG

Best regards,

Dina Ye

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Oomsen Regular Visitor
Regular Visitor

Re: Working hours until today

@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()))
 
 

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 105 members 1,757 guests
Please welcome our newest community members: