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)