NORM.DIST

Updated on

NORM.DIST is a DAX function that returns the normal distribution for a specified mean and standard deviation.

Syntax

NORM.DIST(
   X,
   Mean,
   Standard_dev,
   Cumulative
)
Argument Properties Description
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 mass function.

Return Values

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

Other functions related to NORM.DIST are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/norm-dist-function-dax

2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy