NORM.INV

Applies to: Calculated column Calculated table Measure Visual calculation

The inverse of the normal cumulative distribution for the specified mean and standard deviation.

Syntax

NORM.INV(Probability, Mean, Standard_dev)

Parameters

Term Definition
Probability A probability corresponding to the normal distribution.
Mean The arithmetic mean of the distribution.
Standard_dev The standard deviation of the distribution.

Return value

Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.

Remarks

This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Example

EVALUATE { NORM.INV(0.908789, 40, 1.5) }

Returns

[Value]
42.00000200956628780274132

NORM.S.INV
NORM.S.DIST function
NORM.DIST function