# BETA.INVDAX Function (Statistical)

Returns the inverse of the beta cumulative probability density function (BETA.DIST). If probability = BETA.DIST(x,…TRUE), then BETA.INV(probability,…) = x. The beta distribution can be used in project planning to model probable completion times given an expected completion time and variability.

## Syntax

BETA.INV ( <Probability>, <Alpha>, <Beta> [, <A>] [, <B>] )
Parameter Attributes 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

Scalar A single decimal value.

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.

## Related functions

Other related functions are:

Last update: Jan 11, 2021     » Show contributors

Contributors: Alberto Ferrari, Marco Russo

MSDN documentation: https://docs.microsoft.com/en-us/dax/beta-inv-function-dax

# Context Transition

This function performs a Context Transition if called in a Row Context. Click to read more.

# Row Context

This expression is executed in a Row Context. Click to read more.

# Not recommended

The use of this function is not recommended. See Remarks and Related functions for alternatives.

# Not recommended

The use of this parameter is not recommended.

# Deprecated

This function is deprecated. Jump to the Alternatives section to see the function to use.

# Deprecated

This parameter is deprecated and its use is not recommended.

# DirectQuery compatibility

Limitations are placed on DAX expressions allowed in measures and calculated columns.
The state below shows the DirectQuery compatibility of the DAX function.

### Contribute

Want to improve the content of BETA.INV? Did you find any issue?
Please, report it us! All submissions will be evaluated for possible updates of the content.