NORM.DIST

Applies to: Calculated column Calculated table Measure Visual calculation

Returns the normal distribution for the specified mean and standard deviation.

Syntax

NORM.DIST(X, Mean, Standard_dev, Cumulative)  

Parameters

Term Definition
X The value for which you want the distribution.
Mean The arithmetic mean of the distribution.
Standard_dev The standard deviation of the distribution.
Cumulative* A logical value that determines the form of the function. If cumulative is TRUE, NORM.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.

Return value

The normal distribution for the specified mean and standard deviation.

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.DIST(42, 40, 1.5, TRUE) }

Returns

[Value]
0.908788780274132

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