PERCENTILE.INC
Applies to:
Calculated column
Calculated table
Measure
Visual calculation
Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive.
To return the percentile number of an expression evaluated for each row in a table, use PERCENTILEX.INC.
Syntax
PERCENTILE.INC(<column>, <k>)
Parameters
Term | Definition |
---|---|
column | A column containing the values that define relative standing. |
k | The percentile value in the range 0..1, inclusive. |
Return value
The k-th percentile of values in a range, where k is in the range 0..1, inclusive.
Remarks
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.
Related content
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho