DAX Function Guide

NORM.S.DIST
Empty image or helper icon

Sam McKay

CEO & Founder

How does the NORM.S.DIST 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?

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 Blog Posts

Loading

Considerations when using the NORM.S.DIST?

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.
Related Video Tutorials

Loading

Formula examples using the NORM.S.DIST

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

=NORM.S.DIST(1.333333,FALSE)

=NORM.S.DIST(1.333333,FALSE)

Related Courses

Loading