Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.
Syntax
NORM.S.INV(Probability)
Parameters
| Term | Definition |
|---|---|
Probability |
A probability corresponding to the normal distribution. |
Return value
The inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.
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.S.INV(0.908789) }
Returns
| [Value] |
|---|
| 1.33333467304411 |