Average of a Time value

[Anonymous]

Hi,

I don't know if the concept I'm thinking about even exists but I'll try.

I have a list of Time values that are representing the Time at which the employees of a company are starting to work.

I would like to have a Time with the average entrance time. 

Example.

08.00am

09.00am

10.00am

Expected result 09.00 am

Is this feasible?

Thanks in advance!!

[az38 · Accepted solution]

Hi @Anonymous 

first, create a column

timeColumn = TIMEVALUE('Table'[Time])

then create a measure

avgTime = TIME(0, 0, 0) + calculate( AVERAGE('Table'[Column]), ALL('Table') )

then set avgTime measure data type as time in Modeling ribbon

[camargos88]

Hi @Anonymous ,

You can convert it to a Time field and using the HOUR function you can calculate the average.

Ricardo