Forum Discussion

MtlPhil's avatar
MtlPhil
Regular Visitor
7 years ago
Solved

Calculating capacity utilization across a team

Good afternoon,   I am new to Power BI but quite experienced at Excel - I need a quick hand to better wrap my mind around the intricacies of PowerBI.   I am looking to calculate capacity utilizat...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    MtlPhil,

     

    You may use Matrix visual, drag [Period] and [Resource] to Rows and add measure below.

    Measure =
DIVIDE ( SUM ( Table1[Billable Time] ), SUM ( Table1[Total Time] ) )
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

MtlPhil,

 

You may use Matrix visual, drag [Period] and [Resource] to Rows and add measure below.

Measure =
DIVIDE ( SUM ( Table1[Billable Time] ), SUM ( Table1[Total Time] ) )