topic Re: Unable to Get Median of Calculated Time Column in DAX Commands and Tips

Unable to Get Median of Calculated Time Column

rahul_kumar — Wed, 16 Nov 2022 06:47:23 GMT

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?

Re: Unable to Get Median of Calculated Time Column

Anonymous — Wed, 16 Nov 2022 07:09:56 GMT

Can you share that excel file ?

Re: Unable to Get Median of Calculated Time Column

Anonymous — Fri, 02 Dec 2022 09:20:48 GMT

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.