Forum Discussion

silagy's avatar
silagy
New Member
8 years ago
Solved

Calculating Resource Utilization in Power BI

I am trying to calculate a resource utilization per day. My tables are: ResourceAllocations AllocationID - Int - Unique identifier of a resource allocation ResourceID - Int - Unique identifier o...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi silagy,

     

    WorkingTimePerDays is calculated column, you can get 1440 by changing the summarization to "Don't summarize". The file is here: https://1drv.ms/u/s!ArTqPk2pu-BkgT5MvD6Wbmcw5vbG.

    You can try a measure like this:

     

    Measure =
DIVIDE (
    [TotalAllocations] + [TotalUnAvailabilityTime],
    MIN ( 'rawViews Bks_DWH_ResourcesAllocations'[WorkingTimePerDay] ),
    0
)

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi silagy,

 

Share the download link of your file.  Also, show the exact result expected.