BETA.DIST Function (DAX)

How does the BETA.DIST function (DAX) work?

Returns the beta distribution. The beta distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television.

BETA.DIST Formula Syntax

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

How do you use the BETA.DIST function?

The beta distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television.

Related Blog Posts

Related Support Forum Posts

Understanding DAX Formula
Developing Complex Dax functions

Considerations when using the BETA.DIST function

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.

Related Video Tutorials

Formula examples using the BETA.DIST function

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

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.