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

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.

 

 

 

 

 

 

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

jorgeaguirre

 

What is the error message if you click See details?

 

Best Regards,
Herbert

  • jorgeaguirre's avatar
    jorgeaguirre
    Frequent Visitor
    9 years ago