cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Complicated Available Hours in period

Hi everyone,

 

I'm having a really hard time with this issue...

So I have multiple employees and each employee has one or more contracts. These contracts show how many hours a employee has to work each week together with de dates from when en until when the contract is active. (table with this information is available)

I need to calculate the working days between the two dates in that table. However it has to be possible to calculate this too when there is a filter active like only the available hours for March.

I already have the calculation (calculated column) for the working days between the two dates. But when I apply a filter the result will always be the same.


Does anyone know how to fix this to be dynamically?

 

 

4 REPLIES 4
Community Support Team
Community Support Team

Re: Complicated Available Hours in period

@TimHellegers ,

 

Could you please share some sample data and give the expected result?

 

Regards,

Jimmy Tao

Re: Complicated Available Hours in period

Contract Hours.pngAs you can see in the image above, I have a table with contracts. I have to calculate the hours within the selected date that the employee is available. So, the second table shows some extra information how the formula has to look at the data. It makes use of the working days within the period.

 

The third table is what the formula has to calculate. Because the contract hours are on a weekly basis, the contract hours are divided by 5.  Now the formula can calculate the available contract hours between a certain period.

 

The dashboard view is how it is going to be visible in the dashboard.

 

I don't know how I have to create this formula as I've been working on this formula for many hours...

Highlighted
tex628 New Contributor
New Contributor

Re: Complicated Available Hours in period

Is it possible for you to provide some sample data from your main table?

Re: Complicated Available Hours in period

Hi @tex628 ,

 

The data from the main table is not relevant as this is just employee information and not necessary for calculting the available hours.

What is important is that one employee can have multiple contracts, but not within the same data range.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,006)