NORM.S.DIST DAX Function (Statistical)
Returns the standard normal distribution (has a mean of zero and a standard deviation of one).
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Z |
The value for which you want the distribution. |
|
| Cumulative |
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. |
Return values
The standard normal distribution (has a mean of zero and a standard deviation of one.
Examples
-- NORM.DIST returns the normal distribution for the
-- specified mean and standard deviation
--
-- NORM.DIST ( Value, Mean, StandardDev, Cumulative )
--
-- NORM.S.DIST returns the standard normal distribution
-- (has a mean of zero and a standard deviation of one)
--
-- https://en.wikipedia.org/wiki/Normal_distribution
DEFINE
TABLE SampleData = { 2, 4, 4, 4, 5, 5, 7, 9 }
VAR Mean = AVERAGE ( SampleData[Value] )
VAR StandardDev = STDEV.S ( SampleData[Value] )
VAR Vals = GENERATESERIES ( 0.0, 10, 0.5 )
VAR CumulativeTrue = TRUE -- Cumulative distribution function
VAR CumulativeFalse = FALSE -- Probability density function
EVALUATE
ADDCOLUMNS (
Vals,
"Normal Distr.", -- Probability density function
FORMAT (
NORM.DIST ( [Value], Mean, StandardDev, CumulativeFalse ),
"#,0.00000"
),
"Normal Distr. Cumulative", -- Cumulative distribution function
FORMAT (
NORM.DIST ( [Value], Mean, StandardDev, CumulativeTrue ),
"#,0.00000"
),
"Normal Std. Distr.", -- Cumulative distribution function
FORMAT (
NORM.S.DIST ( [Value], CumulativeFalse ),
"#,0.00000"
),
"Normal Std. Distr. Cumulative", -- Cumulative distribution function
FORMAT (
NORM.S.DIST ( [Value], CumulativeTrue ),
"#,0.00000"
)
)
| Value | Normal Distr. | Normal Distr. Cumulative | Normal Std. Distr. | Normal Std. Distr. Cumulative |
|---|---|---|---|---|
| 0.00 | 0.01212 | 0.00968 | 0.39894 | 0.50000 |
| 0.50 | 0.02037 | 0.01766 | 0.35207 | 0.69146 |
| 1.00 | 0.03242 | 0.03068 | 0.24197 | 0.84134 |
| 1.50 | 0.04886 | 0.05082 | 0.12952 | 0.93319 |
| 2.00 | 0.06972 | 0.08029 | 0.05399 | 0.97725 |
| 2.50 | 0.09419 | 0.12115 | 0.01753 | 0.99379 |
| 3.00 | 0.12047 | 0.17479 | 0.00443 | 0.99865 |
| 3.50 | 0.14588 | 0.24148 | 0.00087 | 0.99977 |
| 4.00 | 0.16726 | 0.32000 | 0.00013 | 0.99997 |
| 4.50 | 0.18156 | 0.40755 | 0.00002 | 1.00000 |
| 5.00 | 0.18659 | 0.50000 | 0.00000 | 1.00000 |
| 5.50 | 0.18156 | 0.59245 | 0.00000 | 1.00000 |
| 6.00 | 0.16726 | 0.68000 | 0.00000 | 1.00000 |
| 6.50 | 0.14588 | 0.75852 | 0.00000 | 1.00000 |
| 7.00 | 0.12047 | 0.82521 | 0.00000 | 1.00000 |
| 7.50 | 0.09419 | 0.87885 | 0.00000 | 1.00000 |
| 8.00 | 0.06972 | 0.91971 | 0.00000 | 1.00000 |
| 8.50 | 0.04886 | 0.94918 | 0.00000 | 1.00000 |
| 9.00 | 0.03242 | 0.96932 | 0.00000 | 1.00000 |
| 9.50 | 0.02037 | 0.98234 | 0.00000 | 1.00000 |
| 10.00 | 0.01212 | 0.99032 | 0.00000 | 1.00000 |
Related functions
Other related functions are:
Last update: Oct 22, 2025 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber
Microsoft documentation: https://docs.microsoft.com/en-us/dax/norm-s-dist-dax
