PERCENTILEX.EXC is a DAX function that returns the exclusive k-th percentile of values resulting from an expression evaluated for each row in a table.
PERCENTILEX.EXC(
Table,
Expression,
K
)| Argument | Properties | Description |
|---|---|---|
| Table | Table over which the Expression will be evaluated. | |
| Expression | Expression to evaluate for each row of the table. | |
| K | Desired percentile value in the interval [1/(n+1),1-1/(n+1)], where n is a number of valid data points. |
The percentile number of an expression evaluated for each row in a table.
If k is zero or blank, percentile rank of 1/(n+1) returns the smallest value. If zero, it is out of range and an error is returned.
If k is nonnumeric or outside the range 0 to 1, an error is returned.
If k is not a multiple of 1/(n + 1), PERCENTILEX.EXC will interpolate to determine the value at the k-th percentile.
PERCENTILEX.EXC will interpolate when the value for the specified percentile is between two values in the array. If it cannot interpolate for the k percentile specified, an error is returned.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Other functions related to PERCENTILEX.EXC are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy