PERCENTILE.INC - Daxplained

PERCENTILE.INC is a DAX function that returns the inclusive k-th percentile of values in a column.

Syntax

PERCENTILE.INC(
   Column,
   K
)

Argument	Properties	Description
Column		A column containing the values.
K		Desired percentile value in the interval [0,1].

The k-th percentile of values in a range, where k is in the range 0..1, inclusive.

If column is empty, BLANK() is returned.
If k is zero or blank, percentile rank of 1/(n+1) returns the smallest value. If zero, it is out of range and an error is returned.
If k is nonnumeric or outside the range 0 to 1, an error is returned.
If k is not a multiple of 1/(n + 1), PERCENTILE.INC will interpolate to determine the value at the k-th percentile.
PERCENTILE.INC 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.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Empty

Other functions related to PERCENTILE.INC are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/percentile-inc-function-dax