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

The PERCENTILEX.INC function (DAX) returns the percentile number of an expression evaluated for each row in a table.


     <table>, <expression>;, k

How do you use the PERCENTILEX.INC function?

Used this function to return the percentile of numbers in a column.

Related Blog Posts

Related Support Forum Posts

How to ignore blank values in percentile calculation?
Dax Calculation question
Dax not working

Considerations when using the PERCENTILEX.INC function

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), PERCENTILEX.EXC will interpolate to determine the value at the k-th percentile.

PERCENTILEX.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 PERCENTILEX.INC function

= PERCENTILEX.INC (Sales,Sales[Sales Amount],0.25)

= PERCENTILEX.INC(‘Stats’,[Rush-Yds],.75)


Related DAX Functions


Related Course Modules



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