BETA.DIST

Updated on

BETA.DIST is a DAX function that returns the beta distribution, commonly used to study variation in percentages across samples.

Syntax

BETA.DIST(
   X,
   Alpha,
   Beta,
   Cumulative,
   A,
   B
)
Argument Properties Description
X The value between A and B at which to evaluate the function.
Alpha A parameter of the distribution.
Beta A parameter the distribution.
Cumulative A logical value that determines the form of the function. If cumulative is TRUE, BETA.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.
A Optional A lower bound to the interval of x.
B Optional An upper bound to the interval of x.

Return Values

Returns the beta distribution.

Remarks

  • If any argument is nonnumeric, BETA.DIST returns the #VALUE! error value.

  • If any argument is not an integer, it is rounded.

  • If alpha ≤ 0 or beta ≤ 0, BETA.DIST returns the#NUM! error value.

  • If x < A, x > B, or A = B, BETA.DIST returns the#NUM! error value.

  • If you omit values for A and B, BETA.DIST 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

Other functions related to BETA.DIST are:

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

2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy