Number.Mod

The function Number.Mod calculates the remainder of dividing the integer number by the divisor. If either the number or the divisor is null, the function will return null. Parameters: - number: the d...

Syntax

Number.Mod(number as nullable number, divisor as nullable number, optional precision as nullable number) as nullable number

About

The function Number.Mod calculates the remainder of dividing the integer number by the divisor. If either the number or the divisor is null, the function will return null. Parameters: - number: the dividend. - divisor: the number by which the dividend is divided.

Explanation

Determine the remainder of dividing 5 by 3 using Power Query function MNumber.Mod(5, 3). The output will be 2.