Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Average Standard Working Hour

Hello,

 

I want to compare Actual Working Hours and Standard Working Hours, but I don't know how to calculate. Correct standard hours should be 1 and 2 respectively. When visualize is with a column chart, actual hour is 27, standard is 3. Below is a sample of data. Please kindly advise.

 

Need Help

3 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Hi,

    Write these measures

    Measure1 = min(data[actual workign hour])

    Measure2 = SUMX(VALUES(Data[Ref Number]),[Measure1])

    Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi 

    Thanks for the reply. Unfotunatelt, it doesn't work. The problem is I can't get correct standard working hour, which is supposed to be an average number

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    Please check the pbix file:

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group