How does the CONFIDENCE.NORM function (DAX) work?

As a type of statistical mean, the CONFIDENCE.NORM function is used to calculate and return the confidence interval for a population mean, using a normal distribution for a supplied probability and sample size.



How do you use the CONFIDENCE.NORM function?

This function is mostly used in financial data analysis to predict a wide range of financial goals. It is done by graphically mapping financial data into a set of variables.

Related Blog Posts

Related Support Forum Posts

Total mean and median
Median Of A Time Column
Get Median Value by Patient (In correct result)

Considerations when using the CONFIDENCE.NORM function

This function has 3 arguments: the Alpha which is the significance level used to compute the confidence level, the Standard_dev which is the standard deviation for the data range, and the Sample Size.

If alpha ≤ 0 or alpha ≥ 1, CONFIDENCE.NORM returns the #NUM! error value.

If standard_dev ≤ 0, CONFIDENCE.NORM returns the #NUM! error value.

If size is not an integer, it is rounded.

If size < 1, CONFIDENCE.NORM returns the #NUM! error value.

If we assume alpha equals 0.05, we need to calculate the area under the standard normal curve that equals (1 – alpha), or 95 percent. This value is ± 1.96. The confidence interval is therefore:


Related Video Tutorials

Formula examples using the CONFIDENCE.NORM function




Related Course Modules


Center of Excellence


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.

Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide