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

The PERCENTILEX.EXC 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.EXC function?

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

Related Blog Posts

Related Support Forum Posts

Dax Calculation question
Dax not working
Nulls/Blanks DAX Measure

Considerations when using the PERCENTILEX.EXC 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.EXC 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.EXC function

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

Related DAX Functions

Related Course Modules



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.