How does the PERCENTILE.INC function (DAX) work?

The PERCENTILE.INC function (DAX) returns the k-th percentile of values in a range, where k is in the range 0.1, inclusive.

PERCENTILE.INC Formula Syntax

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

How do you use the PERCENTILE.INC function?

Use this function to return the percentile number of an expression evaluated for each row in a table.

Related Blog Posts

Related Support Forum Posts

Nulls/Blanks DAX Measure
DAX Measure Exception Report
Developing Complex Dax functions

Considerations when using the PERCENTILE.INC function

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.

Related Video Tutorials

Formula examples using the PERCENTILE.INC function

=PERCENTILE.INC(range,.4)

=PERCENTILE.INC(range,80%)

Related DAX Functions

Related Course Modules

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.