Number.IntegerDivide

 

This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.

Divides two numbers and returns the whole part of the resulting number.

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

ArgumentDescription
number1The Dividend.
number2The Divisor.
optional precisionPrecision of the result.
Number.IntegerDivide(9.2, 3.1) equals 2  

Show: