QUOTIENT

QUOTIENT is a DAX function that returns the integer portion of a division between two numbers.

Syntax

QUOTIENT(
   Numerator,
   Denominator
)

Argument	Properties	Description
Numerator		The dividend.
Denominator		The divisor.

Return Values

A whole number.

Remarks

• If either argument is non-numeric, QUOTIENT returns the #VALUE! error value.

• You can use a column reference instead of a literal value for either argument. However, if the column that you reference contains a 0 (zero), an error is returned for the entire column of values.

The following formulas return the same result, 2.

= QUOTIENT(5,2)

= QUOTIENT(10/2,2)

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