Number.IntegerDivide Function of Power Query
The Number.IntegerDivide function in Power Query (M language) performs integer division between two numbers, returning the quotient without the remainder.
Syntax
Number.IntegerDivide( dividend as nullable number, divisor as nullable number, optional precision as nullable number ) as nullable number
The function has the following parameters:
- dividend: The number to be divided.
- divisor: The number by which to divide. Must not be zero.
Note: If dividend or divisor is null, Number.IntegerDivide returns null.
Example: Divide 25 by 4 using integer division.
Power Query M
let Source = Number.IntegerDivide(25, 4) in Source
The output of the above code is:
6