QUOTIENT Function (DAX)

 

Performs division and returns only the integer portion of the division result. Use this function when you want to discard the remainder of division.

QUOTIENT(<numerator>, <denominator>)  

Parameters

TermDefinition
numeratorThe dividend, or number to divide.
denominatorThe divisor, or number to divide by.

A whole number.

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)  

Math and Trig Functions (DAX)

Community Additions

Show: