PERCENTILE.EXC Function (DAX)

 
System_CAPS_ICON_note.jpg Note


This function is included in SQL Server 2016 Analysis Services (SSAS), Power Pivot in Excel 2016, and Power BI Desktop only. Information provided here is subject to change.

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 (DAX).

PERCENTILE.EXC(<column>, <k>)  

Parameters

TermDefinition
columnA column containing the values that define relative standing.
kThe 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.

PERCENTILEX.EXC Function (DAX)

Community Additions

ADD
Show: