Calculate the median of Time Column

[Anonymous]

Hi, 

I am wanting to calculate the median of a column that has time values. And I want it to be formatting like hh:mm:ss.

Column Example:

Time to Contact

00:11:04

00:21:32

00:13:54

00:12:43

I am using the measure:

= FORMAT(MEDIAN(Table1[Time to Contact]), "HH:MM:SS")

I am geting the error "MEDIAN does not support expressions of type string/Boolean/date

Any help?

[RachC · Accepted solution]

only two step to solve this situation.

first) set new column to set date to second(like unix timestamp)

tosecond = TIMEVALUE(TABLE1[timeconcat]) *1

second)set measure to median your second and convert back to time with DAX FORMAT 

measure = FORMAT(MEDIAN(TABLE1[tosecond]),"hh:mm:ss")

I hope it could help you.

[Anonymous]

Thank You!!

[RachC]

if you works well,pls give a thumb(umm kudo?) for me,thks.

send me message if you me other problem.

[Anonymous]

Times can be cast into floating point #'s... (each increment by 1.0 is 1 full 24-hour day).

I want to say VALUE( ) is the function to use for casting?

[Anonymous]

Thanks! 

How would I structure the new measure?

[Anonymous]

I suspect if just create a new calc column where your time is a floating point number... your above measure will "just work"