Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Utilization of resources based on start/end date.

Hello, im trying to calculate utilization rate for resourcers in a company.

The base table looks like this:


CustomerResourceStart DateEnd Date
Customer AWorker 102.01.202314.04.2023
Customer AWorker 202.01.202329.12.2023
Customer AWorker 316.01.202328.02.2023
Customer AWorker 401.03.202321.04.2023
Customer AWorker 405.05.202306.06.2023
Customer AWorker 501.03.202331.03.2023

I've added also column that is calculating working days between start and end date

I would like to calculate utilization for each Worker in a Matrix Visual.

In column I'd like to have year/month in rows there will be Customer/Workers hierarchy and of course values that will be represented as utilization rate so working days between start/end date divided by working days in that month.

I was trying to create something based on this but I believe it should be slightly modified.


Currently Im receiving something like this:


 and my formula looks like this:

formula =
VAR enddate =
MAX ( 'Calendar'[Date] )
VAR startdate =
MIN ( 'Calendar'[Date] )
VAR result =
SUM ( 'Data'[workingdays] ),
ALL ( 'Calendar' ),
'Data'[Start Date] <= enddate,
'Data'[End Date] > startdate


Community Support
Community Support

Hi @rafal_walisko ,


Please try:

CountDay = 
var _a = MIN('Calendar'[Date])
var _b = MAX('Calendar'[Date])
return SUMX('Table',IF(DATEDIFF(MAXX({_a,[Start Date]},[Value]),MINX({_b,[End Date]},[Value]),DAY)>=0,DATEDIFF(MAXX({_a,[Start Date]},[Value]),MINX({_b,[End Date]},[Value]),DAY)))

Rate = 
DIVIDE([CountDay],SUMX('Table',DATEDIFF([Start Date],[End Date],DAY)))

Final output:


Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Woah 🙂 it loks great, is there any possibility to calculate it only for working days/including holidays? How should I modify the formula 

Hi @rafal_walisko ,


NETWORKDAYS returns the number of whole workdays between two dates (inclusive). Parameters specify which and how many days are weekend days. Weekend days and days specified as holidays are not considered as workdays. You can try to modify the DAX with NETWORKDAYS function.


Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User
Super User

Thanks for the links, I see that you are calculating for example count of projects. In my case I would like to present the number of working days for each person in each project monthly. That the actual problem. I was able to present the project count.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors