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



Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.

Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide