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

Question

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.

Answer 1

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...

Answer 2

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?