PERCENTILE.EXC DAX Function (Statistical)
Returns the k-th (exclusive) percentile of values in a column.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Column |
A column containing the values. |
|
| 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
Percentile value.
Related articles
Learn more about PERCENTILE.EXC in the following 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: Feb 6, 2019 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/percentile-exc-function-dax