PERCENTILEX.INC Function (DAX)

How does the PERCENTILEX.INC function (DAX) work?

The PERCENTILEX.INC function (DAX) returns the percentile number of an expression evaluated for each row in a table.

PERCENTILEX.INC Formula Syntax

PERCENTILEX.INC(
     <table>, <expression>;, k
)

How do you use the PERCENTILEX.INC function?

Used this function to return the percentile of numbers in a column.

Related Blog Posts

Related Support Forum Posts

How to ignore blank values in percentile calculation?
Dax Calculation question
Dax not working

Considerations when using the PERCENTILEX.INC function

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), PERCENTILEX.EXC will interpolate to determine the value at the k-th 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.

Related Video Tutorials

Formula examples using the PERCENTILEX.INC function

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

= PERCENTILEX.INC(‘Stats’,[Rush-Yds],.75)

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.