NORM.INV - Daxplained

NORM.INV is a DAX function that returns the inverse of the normal cumulative distribution for a specified mean and standard deviation.

Syntax

NORM.INV(
   Probability,
   Mean,
   Standard_dev
)

Argument	Properties	Description
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.

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

Returns

[Value]
42.00000200956628780274132

Other functions related to NORM.INV are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/norm-inv-function-dax