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

The NORM.S.DIST function (DAX) returns the standard normal distribution (has a mean of zero and a standard deviation of one).

NORM.S.DIST Formula Syntax

NORM.S.DIST(
Z, Cumulative
)

How do you use the NORM.S.DIST function?

Use this function in place of a table of standard normal curve areas. The NORM.S.DIST function can be used to determine the probability that a random variable that is standard normally distributed would be less than 0.5.

Considerations when using the NORM.S.DIST function

The NORM.S.DIST function syntax has the following arguments:

Z Required. The value for which you want the distribution.
Cumulative Required. Cumulative is a logical value that determines the form of the function. If cumulative is TRUE, NORMS.DIST returns the cumulative distribution function; if FALSE, it returns the probability mass function.