Math and Trig

RAND is a DAX function that returns a random number between 0 (inclusive) and 1 (exclusive), which changes upon recalculation. Syntax Return Values A decimal number. … Read More

POISSON.DIST is a DAX function that returns the Poisson distribution for a given number of events over a specific time period. Syntax Argument Properties Description X … Read More

ODD is a DAX function that rounds a number up to the nearest odd integer. Syntax Argument Properties Description Number The value to round. Return Values … Read More

PERMUT is a DAX function that returns the number of permutations for a given number of objects selected from a total number of objects, where order … Read More

NORM.S.DIST is a DAX function that returns the standard normal distribution with a mean of zero and a standard deviation of one. Syntax Argument Properties Description … Read More

NORM.S.INV is a DAX function that returns the inverse of the standard normal cumulative distribution. Syntax Argument Properties Description Probability A probability corresponding to the normal … Read More

NORM.DIST is a DAX function that returns the normal distribution for a specified mean and standard deviation. Syntax Argument Properties Description X The value for which … Read More

NORM.INV is a DAX function that returns the inverse of the normal cumulative distribution for a specified mean and standard deviation. Syntax Argument Properties Description Probability … Read More

MROUND is a DAX function that rounds a number to the nearest specified multiple. Syntax Argument Properties Description Number The value to round. Multiple The multiple … Read More

LOG10 is a DAX function that returns the base-10 logarithm of a number. Syntax Argument Properties Description Number The positive number for which you want the … Read More