DAX Function Guide

PERCENTILEX.EXC
Empty image or helper icon

Sam McKay

CEO & Founder

How does the PERCENTILEX.EXC work?
The PERCENTILEX.EXC function (DAX) returns the percentile number of an expression evaluated for each row in a table.
PERCENTILEX.EXC Formula Syntax

PERCENTILEX.EXC(
     <table>, <expression>, k
)

How do you use the PERCENTILEX.EXC?

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

Related Blog Posts

Loading

Considerations when using the PERCENTILEX.EXC?

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

Loading

Formula examples using the PERCENTILEX.EXC

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

Related Courses

Loading