PERCENTILE
PERCENTILE(list, p)
Gives the value below which a share p of a list falls, such as the float that the tightest tenth of the schedule is under. p is a share from 0 to 1, not a percentage: write 0.9 for the 90th percentile, because 90 is taken as 1 and gives the largest value.
Arguments
| Argument | What to give it |
|---|---|
| list | A column read from a set of rows, like All[Total float]. Numbers, durations or dates. Blanks are skipped. |
| p | A number from 0 to 1. 0 gives the smallest value, 0.5 the median, 1 the largest. A number outside 0 to 1 is taken as 0 or 1. |
Between two values it interpolates, as Excel's PERCENTILE and PERCENTILE.INC do. A list with no values gives blank.
Examples
Formula=PERCENTILE(All[Total float], 0.1)
The total float that a tenth of the tasks are at or below. The same on every row.
Formula=[Total float] <= PERCENTILE(All[Total float], 0.1)
TRUE for the tasks in the tightest tenth of the schedule by float: a column to color by or filter on.
Measure (on the project)=PERCENTILE(Tasks[Duration], 0.9)
As a measure: the duration nine tasks in ten are no longer than.
Reach for something else when
| You want | Use |
|---|---|
| The middle value | MEDIAN |
| Where this row's value stands, as a share from 0 to 1 | PERCENTRANK |
| Where this row's value stands, as a place: 1st, 2nd, … | RANK |
| The smallest or largest value | MIN, MAX |
Common questions
What does "PERCENTILE needs a list first" mean?
The first argument was a single value, or the two arguments were swapped. The list comes first, the share second.
The editor refuses this=PERCENTILE(0.1, All[Total float])