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.
35,784 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Dave Patrick 426K 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 No comments