PERCENTILE.EXC

PERCENTILE.EXC Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.


Syntax

PERCENTILE.EXC(column, k)

Parameters

column – A column containing the values that define relative standing.
K – The percentile value in the range 0..1, exclusive.

Return Value

The k-th percentile of values in a range, where k is in the range 0..1, exclusive.


Reference Data

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Statistical Functions / PERCENTILE.EXC