# DAX Statistical - PERCENTILE.EXC function

## Description

Returns the kth percentile of values in a range, where 0 < k < 1.

DAX PERCENTILE.EXC function is new in Excel 2016.

## Syntax

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

## Parameters

Sr.No. Parameter & Description
1

column

A column containing the values that define relative standing.

2

k

A number, 0 < k < 1.

## Return Value

The kth percentile of values in a range, where 0 < k < 1.

## Remarks

• If the column is empty, BLANK () is returned.

• If k <= 0, or k >= 1, it is out of range and an error is returned.

• If k is non-numeric, an error is returned.

• If k is not a multiple of 1/(n + 1), PERCENTILE.EXC will interpolate to determine the value at the kth 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.

## Example

```= PERCENTILE.EXC (Sales[Sales Amount],0.25)
```
dax_functions_statistical.htm
##### Kickstart Your Career

Get certified by completing the course