- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
DAX Statistical - PERCENTILEX.INC function
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)