TechNet
Export (0) Print
Expand All

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:
© 2016 Microsoft