Average hours

[jorgeaguirre]

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.

[v-haibl-msft]

@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]

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]

@jorgeaguirre

What is the error message if you click See details?

Best Regards,
Herbert

[jorgeaguirre]

[v-haibl-msft · Accepted solution]

@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