Unable to Get Median of Calculated Time Column

[rahul_kumar]

Hi,
I am trying to calculate the median of a time column h:mm but getting the error : "Median does not support expressions of type string/boolean/date.
I have created a calculated column called "Diff b/w notification to start time" which have time datatype and the values coming like

03:06
08:15

In excel I am easily getting the median of the above number but in power bi I am facing the mentioned issued.
Any help?

[v-rzhou-msft · Accepted solution]

Hi @rahul_kumar ,

I think you can refer to this solved post with similar requirement like yours.

Create two calcualted columns:

tosecond = TIMEVALUE('Table'[Time to Contact]) *1

Median = FORMAT(MEDIAN('Table'[tosecond]),"hh:mm:ss")

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[shreyamukkawar]

Can you share that excel file ?