Table of contents
TOC
Collapse the table of content
Expand the table of content

PERCENTILE.INC Function (DAX)

Owen Duncan|Last Updated: 5/22/2018

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

To return the percentile number of an expression evaluated for each row in a table, use PERCENTILEX.INC Function (DAX).

Syntax

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

Parameters

TermDefinition
columnA column containing the values that define relative standing.
kThe percentile value in the range 0..1, inclusive.

Return Value

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

Remarks

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.INC will interpolate to determine the value at the k-th percentile.

PERCENTILE.INC 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.

See Also

PERCENTILEX.INC Function (DAX)

© 2018 Microsoft