KURTX.S OpenBI

How heavy the tails of an expression's results over a table's rows are, taken as a sample: the sample excess kurtosis.

Excess kurtosis compares the tails with a normal distribution's, which scores 0: positive means more values far out than a bell curve would have, negative fewer (a flat, even spread).

Group: Aggregation. OpenBI’s own: DAX has no function of this name.

Syntax

KURTX.S ( <table>, <expression> )

Returns

Number. The sample excess kurtosis of the results; BLANK for fewer than four, or when they are all equal.

Remarks

• The sample excess kurtosis, the one Excel's KURT gives: from the population's figure g (KURT.P) for n values, ((n + 1) × g + 6) × (n − 1) ÷ ((n − 2) × (n − 3)).
• Rows where the expression is blank are left out; fewer than four results, or results that are all the same, give BLANK.

Compared with DAX

An OpenBI function: DAX has none like it, so a measure or query that uses it works in OpenBI only, not in Power BI or Analysis Services.

Excel's KURT gives the same number for the same values.

Examples

Eight values as a sample and as all there is

EVALUATE
ROW (
    "Sample", KURTX.S ( DATATABLE ( "Value", INTEGER, { { 2 }, { 4 }, { 4 }, { 4 }, { 5 }, { 5 }, { 7 }, { 9 } } ), [Value] ),
    "Population", KURTX.P ( DATATABLE ( "Value", INTEGER, { { 2 }, { 4 }, { 4 }, { 4 }, { 5 }, { 5 }, { 7 }, { 9 } } ), [Value] )
)

Monthly liters of each product

EVALUATE
SUMMARIZECOLUMNS (
    Products[Product],
    "Excess kurtosis", KURTX.S ( VALUES ( Sales[Month] ), [Liters sold] )
)
ORDER BY Products[Product]

Three values are too few

EVALUATE
ROW ( "Excess kurtosis", KURTX.S ( DATATABLE ( "Value", INTEGER, { { 1 }, { 2 }, { 10 } } ), [Value] ) )

Related functions

KURTX.P, KURT.S, SKEWX.S, STDEVX.S.

Last updated 8 November 2026 · OpenBI Studio 0.3.78