Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Utilization rate

I'm hoping that there is an easier way to go about this than what I have been trying to do.  We have trucks that run 24/7. Within there, we have shifts that can start at anytime. The majority run le...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Just going to aggregate to the week/month instead. We are looking for outliers of grossly underutilized resources and this will get us there just as well, if not better. 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Yeah, I've done a fair amount with tricky time manipulation. I have a whole chapter in my book on Time, including Shift calculations although not exactly what you have going on. Also, there is a Utilization recipe. (DAX Cookbook).

 

Here are some links to some of the work I have done around time and such that hopefully will point you in the right direction.

Also always though, sample data, expected output and the logic to get from point A to B is the quickest way to get an answer. 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