none
Median, Standard Deviation - Power Query and Excel RRS feed

  • Question

  • Is there any reason that Power Query MEDIAN is different than Excel MEDIAN function?

    Of course there is workaround but only with M code. I think this is a little confusing for excel users.
    Similar problem (but workaround is easier) is related with Standard Deviation. We have only Standard Deviation for sample in PQ (STDEV.S in Excel)  - not for population (STDEV.P in Excel).

    Bill Szysz

    Friday, May 22, 2015 10:05 AM

Answers

  • The Power Query List.Median function returns an incorrect result for a even list count. It's not a bug - the documentation explains exactly how it works, but it describes an incorrect implementation. I reported this problem ages ago. Like you said, you can write a custom M function for median. It's trivial though, as it is for creating a custom standard deviation (population) function.
    Friday, May 22, 2015 11:07 PM