Forum Discussion

axecap's avatar
axecap
Frequent Visitor
4 years ago
Solved

simple median across a row

What is the best way to achieve the numbers in green?   Having done some looking, i couldn't see. I must not be using the right language to describe what i want.   Thank you!
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    you can add a calculated column like

    median time =
MEDIANX (
    { 'Table'[first_time], 'Table'[second_time], 'Table'[third_time] },
    [Value]
)
axecap's avatar
axecap
Frequent Visitor
4 years ago

Thanks johnt, so you are sort of building a table with those three columns? And then getting the median along the row of interest? Is that what is happening?

I see you need to convert it to an int or you will get an error.

Also finally, when there is 2 numbers, shouldn't it give the average? Seems to just give the lowest value.

johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

Yes, it needs to create a table as all the aggregation functions work on tables, and the values would need to be some sort of numeric type ( whole number, currency, % etc ).

If there is an even number of rows in the table then MEDIANX will return the average of the 2 rows in the middle.

  • axecap's avatar
    axecap
    Frequent Visitor
    4 years ago

    Thanks john, in my case it seems like it was treating the empty values as a zero or something. That is something i'll just have to keep in mind! Thank you again!