# PERCENTILE.INCDAX Function (Statistical)

Returns the k-th (inclusive) percentile of values in a column.

## Syntax

PERCENTILE.INC ( <Column>, <K> )
Parameter Attributes Description
Column

A column containing the values.

K

Desired percentile value in the interval [0,1].

## Return values

Scalar A single variant value.

Percentile value.

## Remarks

PERCENTILEX.INC considers the blank values returned by Expression. This behavior is different from PERCENTILE.INC, which ignores the blank values.

» 1 related article
» 3 related functions

## Examples

```--  PERCENTILE.EXC computed the k-th percentile, exclusive
--  PERCENTILE.INC computed the k-th percentile, inclusive
--
--  Both functions rank the N values from 1 (lowest)
--  to N (highest), then determine the possibly-non-integer
--  calculated rank for the specified percentage argument K
--  (a decimal number between 0.00 and 1.00), and finally
--  use linear interpolation between the closest integer-rank
--  values of the data array.
--
--  For PERCENTILE.EXC the calculated rank is K*(N+1)
--  For PERCENTILE.INC the calculated rank is K*(N-1)+1
--
--  MEDIAN corresponds to PERCENTILE.INC with k=0.50
DEFINE
TABLE SampleData = { 2, 4, 4, 4, 5, 5, 7, 9 }
EVALUATE
{
( "AVERAGE",  AVERAGE ( SampleData[Value] ) ),
( "MEDIAN",   MEDIAN ( SampleData[Value] ) ),
( "PERCENTILE.EXC 0.25",  PERCENTILE.EXC ( SampleData[Value], 0.25 ) ),
( "PERCENTILE.INC 0.25",  PERCENTILE.INC ( SampleData[Value], 0.25 ) ),
( "PERCENTILE.EXC 0.50",  PERCENTILE.EXC ( SampleData[Value], 0.50 ) ),
( "PERCENTILE.INC 0.50",  PERCENTILE.INC ( SampleData[Value], 0.50 ) ),
( "PERCENTILE.EXC 0.75",  PERCENTILE.EXC ( SampleData[Value], 0.75 ) ),
( "PERCENTILE.INC 0.75",  PERCENTILE.INC ( SampleData[Value], 0.75 ) )
}

```
Value1 Value2
AVERAGE 5.00
MEDIAN 4.50
PERCENTILE.EXC 0.25 4.00
PERCENTILE.INC 0.25 4.00
PERCENTILE.EXC 0.50 4.50
PERCENTILE.INC 0.50 4.50
PERCENTILE.EXC 0.75 6.50
PERCENTILE.INC 0.75 5.50
```--
-- Different handling of blanks between PERCENTILE and PERCENTILEX
-- PERCENTILE ignores blank values
-- PERCENTILEX considers blank values
--
DEFINE
TABLE SampleDataWithBlanks =
{ BLANK (), BLANK (), BLANK (), 1, 2, 3, 4 }

EVALUATE
{
( "PERCENTILE.INC 0.25", PERCENTILE.INC ( SampleDataWithBlanks[Value], 0.25 ) ),
( "PERCENTILE.INC 0.50", PERCENTILE.INC ( SampleDataWithBlanks[Value], 0.50 ) ),
( "PERCENTILE.INC 0.75", PERCENTILE.INC ( SampleDataWithBlanks[Value], 0.75 ) ),
( "PERCENTILEX.INC 0.25", PERCENTILEX.INC ( SampleDataWithBlanks, SampleDataWithBlanks[Value], 0.25 ) ),
( "PERCENTILEX.INC 0.50", PERCENTILEX.INC ( SampleDataWithBlanks, SampleDataWithBlanks[Value], 0.50 ) ),
( "PERCENTILEX.INC 0.75", PERCENTILEX.INC ( SampleDataWithBlanks, SampleDataWithBlanks[Value], 0.75 ) )
}

```
Value1 Value2
PERCENTILE.INC 0.25 1.75
PERCENTILE.INC 0.50 2.50
PERCENTILE.INC 0.75 3.25
PERCENTILEX.INC 0.25 (Blank)
PERCENTILEX.INC 0.50 1.00
PERCENTILEX.INC 0.75 2.50

## 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: May 23, 2024     » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Ville-Pietari Louhiala, Kenneth Barber

Microsoft documentation: https://docs.microsoft.com/en-us/dax/percentile-inc-function-dax

2018-2024 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us   » Privacy Policy & Cookies

# 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.

# Volatile

A volatile function may return a different result every time you call it, even if you provide the same arguments. Click to read more.

# 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 PERCENTILE.INC? Did you find any issue?
Please, report it us! All submissions will be evaluated for possible updates of the content.