Forum Discussion

Majfah's avatar
Majfah
Regular Visitor
8 years ago

Using GROUPBY with PERCENTILEX as expression

Hi guys,    I have dataset containing three columns - Department - Timestamp - NbrOfCustomers From this table I would like to compute another table containtng the 90-th percentiles of NbrOfCust...
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Majfah,

 

From this document, we can see that:

"The CURRENTGROUP function takes no arguments and is only supported as the first argument to one of the following aggregation functions: AverageX, CountAX, CountX, GeoMeanX, MaxX, MinX, ProductX, StDevX.S, StDevX.P, SumX, VarX.S, VarX.P." PERCENTILEX is not a supported function to be used inside CURRENTGROUP() function.

 

Regards,

Yuliana Gu