[power query] how to use list.percentile in table group

扬 夏 21 Reputation points
2021-03-04T00:55:25.663+00:00

73984-3.png

I have some daily data which i wanna group by month in average and 95%percentile.
so i found function [list.percentile] but can't be use in function [table group].

it's really appreciated if someone can give some help.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,555 questions
0 comments No comments
{count} votes

Accepted answer
  1. Lz._ 8,991 Reputation points
    2021-03-04T05:58:29.033+00:00

    Hi @扬 夏

    If the translation of the error you get is Expression.Error The name 'List.Percentile' wasn't recognized.... this means that function isn't available in the product you run

    It seems the function has been added very recently. I was running Excel 365 v2101 b13628.20448 where it wasn't available. Upgraded to v2102 b13801.20266 today where it's now available and can be used no problem in a grouping operation

    74103-demo.png

    Hope this helps & next time please provide a translation of your columns, error message...


1 additional answer

Sort by: Most helpful
  1. 扬 夏 21 Reputation points
    2021-03-05T05:41:16.543+00:00

    Thank you very much!
    As you say it works well after updated.

    By the way
    Is there any function in power query which can work like "rankif()" in excel?