DAX Statistical - PERCENTILEX.INC function


Advertisements

Description

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

Syntax

PERCENTILEX.INC (<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 is zero or blank, percentile rank of 1 / (n - 1) returns the smallest value.

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

  • If k < 0, or k > 1, an error is returned.

  • If k is not a multiple of 1 / (n - 1), PERCENTILEX.INC will interpolate to determine the value at the kth percentile.

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

Example

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

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements