POISSON.DIST Function (DAX)

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

The POISSON.DIST function (DAX) calculates the Poisson probability mass function.

POISSON.DIST Formula Syntax

POISSON.DIST(
     x,mean,cumulative
)

How do you use the POISSON.DIST function?

A common application of the Poisson distribution is predicting the number of events over a specific time, such as the number of cars arriving at a toll plaza in 1 minute.

Related Blog Posts

Related Support Forum Posts

Dax Calculation question
Dax not working
DAX Buffer Calculation Query

Considerations when using the POISSON.DIST function

If x is not an integer, it is rounded.

If x or mean is nonnumeric, POISSON.DIST returns the #VALUE! error value.

If x < 0, POISSON.DIST returns the #NUM! error value.

If mean < 0, POISSON.DIST returns the #NUM! error value.

POISSON.DIST is calculated as follows.

For cumulative = FALSE:

Formula

For cumulative = TRUE:

Formula

Related Video Tutorials

Formula examples using the POISSON.DIST function

=POISSON.DIST(C5,C6,FALSE)

=POISSON.DIST(B5,B6,TRUE)

=POISSON.DIST(A2,A3,FALSE)

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.