Microsoft Power Query Median in Group By Incorrect

Ashley Lang 1 Reputation point
2022-08-15T19:47:35.38+00:00

The List.Median function in Power Query calculates a median correctly for an even number of items as was resolved in this post below.

https://social.technet.microsoft.com/Forums/lync/en-US/73b90d15-34c0-4613-a0c2-b33b57bfa3be/why-does-mircosoft-power-query-still-use-calculate-a-median-function-in-a-quotuniquequot-way?forum=powerquery

However, using the median operation in the Group By feature of Power Query still returns the lower of the two middle numbers as the median. Shouldn't this have also been fixed years ago along with the original bug?

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,205 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dave Patrick 426.1K Reputation points MVP
    2022-08-15T19:51:55.13+00:00

    Power query is not currently supported here on Q&A. The product group for Power Query actively monitors questions over at
    https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services

    --please don't forget to Accept as answer if the reply is helpful--

    0 comments