TimeSheet Report - Resource Utilization for Week/Month

[Anonymous]

Please find the below timesheet report I have created to track everyone Planned and Actual hours.

I need to create resource utilization field for every resource to check how much % he has been utilized every week/month based on the planned hours. Normal effort is 8 hrs per day.

Kindly help

[v-diye-msft · Accepted solution]

Hi @Anonymous 

It's hard to provide the exact formula without the dummy data, but I believe you can refer to the similar threads below for some hints:

https://community.powerbi.com/t5/Desktop/Computing-Resource-Utilization-Per-Day-Week-and-Month/td-p/314915 

https://community.powerbi.com/t5/Desktop/Calculating-Utilization-Multiple-Employees-different-Number-of/m-p/690077 

[aj1973]

Hi @Anonymous 

You are definitly going to need to use Time Intelligence functions to achieve that. For that create a table Calendar and link it to your Time sheet table through dates. Then you can use those time intelligence function into the calculate function to get the calculations needed for the week/month and more.