BETA.INV Function (DAX)

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

BETA.INV function (DAX) returns the inverse of the beta cumulative probability density function for a supplied probability. 

BETA.INV Formula Syntax

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

How do you use the BETA.INV function?

This function can be used in processes made during project planning to provide probable completion times. 

Related Blog Posts

Related Support Forum Posts

Calculating a lifetime average and normal distribution
Combining aggregating & iterating functions to calculate median
Measures not calculating sum in matrix

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
Center of Excellence

DOWNLOAD


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
Membership