Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
Calculated column
Calculated table
Measure
Visual calculation
Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
To return the percentile number of an expression evaluated for each row in a table, use PERCENTILEX.EXC function.
PERCENTILE.EXC(<column>, <k>)
Term | Definition |
---|---|
column |
A column containing the values that define relative standing. |
k |
The percentile value in the range 0..1, exclusive. |
The k-th percentile of values in a range, where k is in the range 0..1, exclusive.
If column is empty, BLANK() is returned.
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), PERCENTILE.EXC will interpolate to determine the value at the k-th percentile.
PERCENTILE.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.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today