## 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.

## Related Support Forum Posts

Dax Calculation question
Dax not working
DAX Buffer Calculation Query

## 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.

## Formula examples using the NORM.S.DIST function

EVALUATE { NORM.S.DIST(1.333333, TRUE) }

=NORM.S.DIST(1.333333,FALSE)

=NORM.S.DIST(C5,FALSE)

## Related Course Modules 