BETA.INV

BETA.INV is a DAX function that returns the inverse of the beta cumulative probability density function, useful for modeling probable completion times.

Syntax

BETA.INV(
   Probability,
   Alpha,
   Beta,
   A,
   B
)

Argument	Properties	Description
Probability		A probability associated with the beta distribution.
Alpha		A parameter of the distribution.
Beta		A parameter the distribution.
A	Optional	A lower bound to the interval of x.
B	Optional	An upper bound to the interval of x.

Return Values

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

Remarks

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

• This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Empty

Related functions

Other functions related to BETA.INV are:

• BETA.DIST

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/beta-inv-function-dax