EXPON.DIST

EXPON.DIST is a DAX function that returns the exponential distribution for modeling the time between events.

Syntax

EXPON.DIST(
   X,
   Lambda,
   Cumulative
)

Argument	Properties	Description
X		The value of the function.
Lambda		The parameter value.
Cumulative		A logical value that indicates which form of the exponential function to provide. If cumulative is TRUE, EXPON.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.

Return Values

Returns the exponential distribution.

Remarks

• If x or lambda is nonnumeric, EXPON.DIST returns the #VALUE! error value.

• If x or lambda is not an integer, it is rounded.

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

• If lambda ≤ 0, EXPON.DIST returns the #NUM! error value.

• The equation for the probability density function is:

  $$f(x;\lambda )=\lambda e^{-\lambda x}$$

• The equation for the cumulative distribution function is:

  $$F(x;\lambda )=1-e^{-\lambda x}$$

• This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Empty

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/expon-dist-function-dax