NORM.S.DIST
Applies to: Calculated column Calculated table Measure Visual calculation
Returns the standard normal distribution (has a mean of zero and a standard deviation of one).
Syntax
NORM.S.DIST(Z, Cumulative)
Parameters
Term | Definition |
---|---|
Z | The value for which you want the distribution. |
Cumulative | Cumulative is a logical value that determines the form of the function. If cumulative is TRUE, NORM.S.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function. |
Return value
The standard normal 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.DIST(1.333333, TRUE) }
Returns
[Value] |
---|
0.908788725604095 |