cancel
Showing results for
Did you mean:
Highlighted
Helper V

## Calculate the median of Time Column

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Helper I

## Re: Calculate the median of Time Column

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")`

6 REPLIES 6
Memorable Member

## Re: Calculate the median of Time Column

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?

Helper V

## Re: Calculate the median of Time Column

Thanks!

How would I structure the new measure?

Memorable Member

## Re: Calculate the median of Time Column

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

Helper I

## Re: Calculate the median of Time Column

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")`

Helper V

Thank You!!

Helper I

## Re: Calculate the median of Time Column

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

send me message if you me other problem.

Announcements

#### ‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

#### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

#### April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors