# PERCENTILEX.EXCDAX Function (Statistical)

Returns the k-th (exclusive) percentile of an expression values in a table.

## Syntax

PERCENTILEX.EXC ( <Table>, <Expression>, <K> )
Parameter Attributes Description
Table

Table over which the Expression will be evaluated.

Expression

Expression to evaluate for each row of the table.

K

Desired percentile value in the interval [1/(n+1),1-1/(n+1)], where n is a number of valid data points.

## Return values

Scalar A single variant value.

Percentile value.

## Related articles

• Statistical Patterns

DAX includes a few statistical aggregation functions, such as average, variance, and standard deviation. Other typical statistical calculations require you to write longer DAX expressions. Excel, from this point of view, has a much richer language. The Statistical Patterns are a collection of common statistical calculations: median, mode, moving average, percentile, and quartile. » Read more

## Related functions

Other related functions are:

Last update: Jan 11, 2021     » Show contributors

Contributors: Alberto Ferrari, Marco Russo

MSDN documentation: https://docs.microsoft.com/en-us/dax/percentilex-exc-function-dax

# Context Transition

This function performs a Context Transition if called in a Row Context. Click to read more.

# Row Context

This expression is executed in a Row Context. Click to read more.

# Not recommended

The use of this function is not recommended. See Remarks and Related functions for alternatives.

# Not recommended

The use of this parameter is not recommended.

# Deprecated

This function is deprecated. Jump to the Alternatives section to see the function to use.

# Deprecated

This parameter is deprecated and its use is not recommended.

# DirectQuery compatibility

Limitations are placed on DAX expressions allowed in measures and calculated columns.
The state below shows the DirectQuery compatibility of the DAX function.

### Contribute

Want to improve the content of PERCENTILEX.EXC? Did you find any issue?
Please, report it us! All submissions will be evaluated for possible updates of the content.