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]
)

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

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.

=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)