How does the QUOTIENT function (DAX) work?

The 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 Formula Syntax

     <numerator>, <denominator>

How do you use the QUOTIENT function?

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.

Related Blog Posts

Related Support Forum Posts

Calculating Employee Anniversaries
Need help with complex ranking/cumulative scenario
DATEADD within SUMX returning 0 or blank

Considerations when using the QUOTIENT function

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

Related Video Tutorials

Formula examples using the QUOTIENT function


Related Course Modules



To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.