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. 

edhans's avatar
edhans
Community Champion
6 years ago

We'd need to see some data to really work on this. Additionally, you should put all your column calculations in Power Query if possible, not in DAX. See links below for the reasons. As far as data, we'd also need to see some expected output.

 

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum

 

In general, try to avoid calculated columns. There are times to use them, but it is rare. Getting data out of the source system, creating columns in Power Query, or DAX Measures are usually preferred to calculated columns. See these references:
Calculated Columns vs Measures in DAX
Calculated Columns and Measures in DAX
Storage differences between calculated columns and calculated tables
Creating a Dynamic Date Table in Power Query