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