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

NORM.INV function
NORM.DIST function
NORM.S.INV