QUOTIENT Function (DAX)
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
QUOTIENT(
<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
=QUOTIENT(5,2)
Related Course Modules
DOWNLOAD
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.
