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:
For cumulative = TRUE:
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)
