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