NORM.S.INV
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 |