DAX Function Guide

Sam McKay

CEO & Founder

The BETA.DIST function (DAX) returns the cumulative probability density function for a supplied set of parameters.

BETA.DIST(
x,alpha,beta,cumulative,[A],[B]
)

As a type of statistical function, it returns the beta distribution which is used to study the variation of a percentage across samples.

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.

=BETA.DIST (0.2,3,9,FALSE,0,1)

=BETA.DIST (0.2,3,9,TRUE,0,1)

=BETA.DIST (2,8,10,TRUE,1,3)