DAX Function Guide

QUOTIENT
Empty image or helper icon

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