How does the POISSON.DIST function (DAX) work?
The POISSON.DIST function (DAX) calculates the Poisson probability mass function.
POISSON.DIST Formula Syntax
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
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:
For cumulative = TRUE:
Related Video Tutorials
Formula examples using the POISSON.DIST function
Related Course Modules
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.