BETA.INV Function (DAX)

How does the BETA.INV function (DAX) work?

Returns the inverse of the beta cumulative probability density function (BETA.DIST).

BETA.INV Formula Syntax

BETA.INV(
     probability,alpha,beta,[A],[B]
)

How do you use the BETA.INV function?

This function calculates the inverse of the cumulative beta probability density function for a supplied probability.

Related Blog Posts

Related Support Forum Posts

Understanding DAX Formula
Developing Complex Dax functions

Considerations when using the BETA.INV function

If any argument is nonnumeric, BETA.INV returns the #VALUE! error value.

If any argument is not an integer, it is rounded.

If alpha ≤ 0 or beta ≤ 0, BETA.INV returns the #NUM! error value.

If probability ≤ 0 or probability > 1, BETA.INV returns the #NUM! error value.

If you omit values for A and B, BETA.INV uses the standard cumulative beta distribution, so that A = 0 and B = 1.

Related Video Tutorials

Formula examples using the BETA.INV function

=BETA.INV( 0.2, 4, 5, 0, 1 )

=BETA.INV(0.2,1.5,4,1,2)

=BETA.INV(0.685470581,8,10,1,3)

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.