Showing results for 
Search instead for 
Did you mean: 

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?



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?



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

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

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 47 members 878 guests
Please welcome our newest community members: