DAX Function Guide

PERCENTILE.EXC
Empty image or helper icon

Sam McKay

CEO & Founder

How does the PERCENTILE.EXC work?
The PERCENTILE.EXC function (DAX) returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
PERCENTILE.EXC Formula Syntax

PERCENTILE.EXC(
     <column>, <k>
)

How do you use the PERCENTILE.EXC?

The PERCENTILE.EXC function calculates the “kth percentile” for a set of data. The k:th percentile is a value below which k percent of values in the data set fall. A percentile calculated with .4 as k means 40% percent of values are less than or equal to the calculated result, a percentile calculated with k = .9 means 90% percent of values are less than or equal to the calculated result.

Related Blog Posts

Loading

Considerations when using the PERCENTILE.EXC?

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

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

=PERCENTILE.EXC(range,.4)

=PERCENTILE.EXC(range,.9)

=PERCENTILE.EXC(range,80%)

Related Courses

Loading