← Back to Number functions

Number.IntegerDivide

The function Number.IntegerDivide calculates the quotient of two numbers (number1 and number2) and returns only the whole number part. If either number1 or number2 is not specified, the result will be...

Syntax

Number.IntegerDivide(number1 as nullable number, number2 as nullable number, optional precision as nullable number) as nullable number

About

The function Number.IntegerDivide calculates the quotient of two numbers (number1 and number2) and returns only the whole number part. If either number1 or number2 is not specified, the result will be null. The parameter number1 represents the dividend, while number2 represents the divisor.

Explanation

Divide 6 by 4 by using the Power Query M function Number.IntegerDivide(6, 4), the output will be 1. To divide 8.3 by 3, use the Power Query M function Number.IntegerDivide(8.3, 3), the output will be 2.