# DAX Statistical - PERCENTILEX.EXC function

## Description

Returns the percentile number of an expression evaluated for each row in a table.

DAX PERCENTILEX.EXC function is new in Excel 2016.

## Syntax

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

## Parameters

Sr.No. Parameter & Description
1

table

The table containing the rows for which the expression will be evaluated.

2

expression

The expression to be evaluated for each row of the table.

3

k

A number, 0 < k < 1.

## Return Value

The percentile number of an expression evaluated for each row in a table.

## Remarks

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

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

• If k is blank, percentile rank of 1 / (n+1) returns the smallest value.

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

## Example

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