A
C
- CALCULATE
- CALCULATETABLE
- CALENDAR
- CALENDARAUTO
- CEILING
- CHISQ.DIST
- CHISQ.DIST.RT
- CHISQ.INV
- CHISQ.INV.RT
- CLOSINGBALANCEMONTH
- CLOSINGBALANCEQUARTER
- CLOSINGBALANCEYEAR
- COALESCE
- COLUMNSTATISTICS
- COMBIN
- COMBINA
- COMBINEVALUES
- CONCATENATE
- CONCATENATEX
- CONFIDENCE.NORM
- CONFIDENCE.T
- CONTAINS
- CONTAINSROW
- CONTAINSSTRING
- CONTAINSSTRINGEXACT
- CONVERT
- COS
- COSH
- COT
- COTH
- COUNT
- COUNTA
- COUNTAX
- COUNTBLANK
- COUNTROWS
- COUNTX
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- CROSSFILTER
- CROSSJOIN
- CUMIPMT
- CUMPRINC
- CURRENCY
- CURRENTGROUP
- CUSTOMDATA
D
E
I
N
O
P
R
S
- SAMEPERIODLASTYEAR
- SAMPLE
- SEARCH
- SECOND
- SELECTCOLUMNS
- SELECTEDMEASURE
- SELECTEDMEASUREFORMATSTRING
- SELECTEDMEASURENAME
- SELECTEDVALUE
- SIGN
- SIN
- SINH
- SLN
- SQRT
- SQRTPI
- STARTOFMONTH
- STARTOFQUARTER
- STARTOFYEAR
- STDEVX.P
- STDEVX.S
- STDEV.P
- STDEV.S
- SUBSTITUTE
- SUBSTITUTEWITHINDEX
- SUM
- SUMMARIZE
- SUMMARIZECOLUMNS
- SUMX
- SWITCH
- SYD
T
U
Syntax
The syntax for the NORM.S.DIST function is as follows:
NORM.S.DIST(x, cumulative)
Where:
- `x` is the value for which you want to calculate the standard normal cumulative distribution function.
- `cumulative` is a boolean value that determines the form of the distribution to be used. If `cumulative` is `TRUE` or omitted, NORM.S.DIST returns the cumulative distribution function. If `cumulative` is `FALSE`, NORM.S.DIST returns the probability density function.
Examples
Let's look at some examples of how to use the NORM.S.DIST function in Power BI.
Example 1: Calculate the standard normal cumulative distribution function
Suppose you have a dataset with a column named `Data` that contains a set of values. You want to calculate the standard normal cumulative distribution function for each value in the column. To do this, you can use the following DAX formula:
=CALCULATE(NORM.S.DIST(Data, TRUE))
This formula will calculate the standard normal cumulative distribution function for each value in the `Data` column.
Example 2: Calculate the probability density function
Suppose you want to calculate the probability density function for a specific value in your dataset. To do this, you can use the following DAX formula:
=NORM.S.DIST(Data, FALSE)
This formula will calculate the probability density function for the value in the `Data` column.
The NORM.S.DIST function is a powerful tool for calculating the standard normal cumulative distribution function and probability density function in Power BI. By understanding the syntax and examples provided in this article, you should be able to effectively use this function in your own datasets.