Forum Discussion

kangkopi15's avatar
kangkopi15
Helper I
2 years ago
Solved

Utiisation per week

Dear Experts, I need your help again, I want to sum total the utilization per week, except for the activity called "Leave" Activity Utilisation % Start Date Start Date of the week Reso...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi kangkopi15 ，

    You can create a calculated column as below to get it, please find the details in the attachment.

    Utilisation per week = 
CALCULATE(
    SUM('Table'[Utilisation %]),
    FILTER(
        'Table',
        'Table'[Start Date of the week] = EARLIER('Table'[Start Date of the week]) &&
        'Table'[Resource] = EARLIER('Table'[Resource]) &&
        'Table'[End Date of the week] = EARLIER('Table'[End Date of the week])
    )
) / 100

    Best Regards

lbendlin's avatar
lbendlin
Super User
2 years ago

No need for calculation

 

 

  • kangkopi15's avatar
    kangkopi15
    Helper I
    2 years ago

    ah you're right, thank you, however, I have this formula in my Excel, and I wonder can apply the same for powerBI, essentially I want to have the average utilisation per week.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi kangkopi15 ,

      You can follow the steps below to get it:

      1. Create table visual

      2. Apply the field [Resource], [Start Date of the week], [End Date of the week], [Utilisation %] with the aggregation Sum (which just like suggested by lbendlin ) and  [Utilisation %] with the aggregation Average as below screenshot

      Best Regards

      • kangkopi15's avatar
        kangkopi15
        Helper I
        2 years ago

        hi Anonymous lbendlin thank you, appreciate your response, I followed your steps and managed to get the table, I think the reason why I need the  formula is for the filter and another visualization, the actual table is more comprehensive with more columns and tables, that's why I need to have the correct measurement