MOD DAX Function (Math and Trig)
Returns the remainder after a number is divided by a divisor.
Syntax
MOD ( <Number>, <Divisor> )
| Parameter | Attributes | Description |
|---|---|---|
| Number |
The number for which you want to find the remainder after the division is performed. |
|
| Divisor |
The number by which you want to divide. |
Return values
Scalar A single integer value.
An integer number.
Examples
MOD ( 0, 2 ) -- returns 0 MOD ( 5, 2 ) -- returns 1 MOD ( 6, 3 ) -- returns 0 MOD ( 7, 3 ) -- returns 1 MOD ( 8, 3 ) -- returns 2
Related functions
Other related functions are:
Last update: Dec 14, 2018 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/mod-function-dax