PERCENTILEX.EXC Returns the percentile number of an expression evaluated for each row in a table.
Syntax
PERCENTILEX.EXC(table, expression, k)
Parameters
table – The table containing the rows for which the expression will be evaluated.
Expression – The expression to be evaluated for each row of the table.
K – The desired percentile value in the range 0 to 1 exclusive.
Return Value
The percentile number of an expression evaluated for each row in a table.
Reference Data
https://docs.microsoft.com/en-us/dax/dax-function-reference