NORM.S.INV Function (DAX)

How does the NORM.S.INV function (DAX) work?

The NORM.S.INV function (DAX) returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.

NORM.S.INV Formula Syntax


How do you use the NORM.S.INV function?

This function will calculate the inverse normal cumulative distribution for a given probability value. The precision of NORM.S.INV depends on the precision of NORM.S.DIST. NORM.S.INV uses an iterative search technique.

Related Blog Posts

Related Support Forum Posts

Dax Calculation question
Dax not working
DAX Buffer Calculation Query

Considerations when using the NORM.S.INV function

The NORM.S.INV function uses only one argument:

  1. Probability (required argument) – This is the probability corresponding to the normal distribution. It is the value at which we want to evaluate the inverse function.

Related Video Tutorials

Formula examples using the NORM.S.INV function

EVALUATE { NORM.S.INV(0.908789) }


=NORM.S.INV( 0.55 )

Related DAX Functions

Related Course Modules



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