Forum Discussion

jorgeaguirre's avatar
jorgeaguirre
Frequent Visitor
9 years ago
Solved

Average hours

Hi, I'm new to "power bi" I'm working on a project with direct query

 

I need to get the AVERAGE, grouped by hours.

 

 

 

 

Dashboards
Data Modeling
Reports
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    jorgeaguirre

     

    Do you have a Arrival Time column in your table? If yes, please try with following measure.

     

    AVERAGE = 
FORMAT (
    CALCULATE (
        AVERAGE ( Table1[Arrival Time] ),
        ALLEXCEPT ( Table1, Table1[TimeHour] )
    ),
    "HH:MM: SS"
)

     

    Best Regards,
    Herbert

5 Replies

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    jorgeaguirre

     

    Do you have a Arrival Time column in your table? If yes, please try with following measure.

     

    AVERAGE = 
FORMAT (
    CALCULATE (
        AVERAGE ( Table1[Arrival Time] ),
        ALLEXCEPT ( Table1, Table1[TimeHour] )
    ),
    "HH:MM: SS"
)

     

    Best Regards,
    Herbert

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    jorgeaguirre

     

    Has your problem got resolved? If yes, you can mark the right answer as solution so that other people who have the same problem can find the right answer quickly.

     

    Best Regards,
    Herbert

    • jorgeaguirre's avatar
      jorgeaguirre
      Frequent Visitor
      9 years ago

       

      Hi, if your answer helped me with the above problem.

      But I have another very similar problem in that I try to use the same formula but I can not make it work.

       

      I'm working with "direct query" and I need to get the average "work time"

      Something very similar to this. AVERAGE_WT = FORMAT (AVERAGE (View_AllRequests [Average Work Time]), "HH: MM: SS")

      But I always get error.