PERCENTILE.INC Function (DAX)

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%)

=PERCENTILE.INC(scores,E5)

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership