DAX Function Guide
QUOTIENT
Sam McKay
CEO & Founder
How does the QUOTIENT 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?
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
Loading
Considerations when using the QUOTIENT?
If either argument is non-numeric, QUOTIENT returns the #VALUE! error value.
Related Video Tutorials
Loading
Formula examples using the QUOTIENT
=QUOTIENT(5,2)
Related Courses
Loading