Table of contents
TOC
Collapse the table of content
Expand the table of content

QUOTIENT Function (DAX)

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

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

Syntax

QUOTIENT(<numerator>, <denominator>)  

Parameters

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

Return Value

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.

Example

The following formulas return the same result, 2.

=QUOTIENT(5,2)  
=QUOTIENT(10/2,2)  

See Also

Math and Trig Functions (DAX)

© 2018 Microsoft