BETA.DIST Function (DAX)

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

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

BETA.DIST Formula Syntax


How do you use the BETA.DIST function?

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

Related Blog Posts

Related Support Forum Posts

Report client usage
Data types text and numeric
How to get descriptive statistics for multiple columns

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



Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.

Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide