Forum Discussion
Daily utiliation
Hi - I an working with process data - that is an instance of the process has a start and a stop timestamp that can span several days. I need to calculate the daily utilization of a ressource being used (the real use case is bed utilization in a hospital) - any ideas?
/Mads
2 Replies
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, take a look at these two Quick Measures as I think you want something like them.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365Hi MagicMads
By definition, the utilization % is the percent of time a resource worked compared to the total available hours the resource could work.
Calculating Utilization % = Actual Number of Hours Worked (by the resource) divided by the Total Available Hours.
So please let me know how you define the Actual Number of Hours Worked (by the resource) and the Total Available Hours in your scenario. Also, an example dataset is much better for analysis.
Best Regards
Maggie
