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


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 )



Related Course Modules



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.