Skip to content

Automatic translation — the Portuguese version is the reference. View in Portuguese

PERCENTIL

On this page (10)

Percentile of the column (p between 0 and 1).

FieldValue
CategoryStatistics
TypeAggregation (operates on a set of rows)
Arity2 arguments (fixed)
Compiles to SQL (calculated column)No
VersionFormula engine v3.

Aliases#

Canonical name: PERCENTIL. Accepted aliases (case-insensitive): percentile.

Syntax#

code
PERCENTIL(coluna; arg2)

The 1st argument is the name of a column (bare identifier); the others are expressions.

Returns#

Number.

Null handling#

Blank values are IGNORED (they don't count as zero); a group with no values returns blank.

Evaluation context#

Aggregation — goes through the rows of the visual's current group.

Differences from DAX#

  • DAX equivalent: PERCENTILE.INC
  • Compatibility: Compatible with DAX
  • Note: Inclusive linear interpolation (index (n-1)·p), same as PERCENTILE.INC. Accepts p in 0–1 or 0–100.

Examples#

code
PERCENTIL(ticket; 0,9)

Example with values#

Input: column v = 10, 20, 30 at percentile 0,5.

code
PERCENTIL(v; 0,5)  →  20

Expected result: 20

Business example#

Summarize a period — total revenue, average ticket, spread of the value per order.

Common errors#

PERCENTIL: p deve ficar entre 0 e 1 (ou 0 e 100).


← Back to the formula index

Related links