How does the NORM.DIST function (DAX) work?

The NORM.DIST function (DAX) returns the normal distribution for the specified mean and standard deviation.

NORM.DIST Formula Syntax

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

How do you use the NORM.DIST function?

This function will calculate the probability that variable x falls below or at a specified value. That is, it will calculate the normal probability density function or the cumulative normal distribution function for a given set of parameters.

Considerations when using the NORM.DIST function

The NORM.DIST uses the following arguments:

X (required argument) – This is the value for which we wish to calculate the distribution.
Mean (required argument) – The arithmetic mean of the distribution.
Standard_dev (required argument) – The standard deviation of the distribution.
Cumulative (required argument) – This is a logical value. It specifies the type of distribution to be used: TRUE (Cumulative Normal Distribution Function) or FALSE (Normal Probability Density Function).

We can use 1 for TRUE and 0 for FALSE when entering the formula.