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

扬 夏 21 Reputation points


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

    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


    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

    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?