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

DAX

NORM.INV(Probability, Mean, Standard_dev)

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.

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

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

DAX

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

Returns

[Value]
42.00000200956628780274132