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

NORM.S.INV(
     Probability
)

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.908789)

=NORM.S.INV( 0.55 )

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.