MOD DAX Function (Math and Trig)
Returns the remainder after a number is divided by a divisor.
Syntax
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
The remainder value.
» 3 related functions
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
-- MOD returns the remainder of an integer division by A and B -- whereas QUOTIENT returns the integer part of the quotient DEFINE VAR Val1 = SELECTCOLUMNS ( GENERATESERIES ( 3, 6, 1 ), "Val1", [Value] ) VAR Val2 = SELECTCOLUMNS ( GENERATESERIES ( 2, 4, 1 ), "Val2", [Value] ) EVALUATE ADDCOLUMNS ( CROSSJOIN ( Val1, Val2 ), "Division", DIVIDE ( [Val1], [Val2] ), "QUOTIENT", QUOTIENT ( [Val1], [Val2] ), "MOD", MOD ( [Val1], [Val2] ), "Mod/Div", MOD ( [Val1], [Val2] ) / [Val2] ) ORDER BY [Val1] DESC, [Val2] ASC
Val1 | Val2 | Division | Quotient | MOD | Mod/Div |
---|---|---|---|---|---|
6 | 2 | 3.00 | 3 | 0 | 0.00 |
6 | 3 | 2.00 | 2 | 0 | 0.00 |
6 | 4 | 1.50 | 1 | 2 | 0.50 |
5 | 2 | 2.50 | 2 | 1 | 0.50 |
5 | 3 | 1.67 | 1 | 2 | 0.67 |
5 | 4 | 1.25 | 1 | 1 | 0.25 |
4 | 2 | 2.00 | 2 | 0 | 0.00 |
4 | 3 | 1.33 | 1 | 1 | 0.33 |
4 | 4 | 1.00 | 1 | 0 | 0.00 |
3 | 2 | 1.50 | 1 | 1 | 0.50 |
3 | 3 | 1.00 | 1 | 0 | 0.00 |
3 | 4 | 0.75 | 0 | 3 | 0.75 |
-- MOD returns the remainder of an integer division by A and B -- whereas QUOTIENT returns the integer part of the quotient. DEFINE VAR Val1 = SELECTCOLUMNS ( GENERATESERIES ( 0.5, 3.3, 1.6 ), "Val1", [Value] ) VAR Val2 = SELECTCOLUMNS ( GENERATESERIES ( 0.5, 2.8, 1.1 ), "Val2", [Value] ) EVALUATE ADDCOLUMNS ( CROSSJOIN ( Val1, Val2 ), "Division", DIVIDE ( [Val1], [Val2] ), "QUOTIENT", QUOTIENT ( [Val1], [Val2] ), "MOD", MOD ( [Val1], [Val2] ), "Mod/Div", MOD ( [Val1], [Val2] ) / [Val2] ) ORDER BY [Val1] DESC, [Val2] ASC
Val1 | Val2 | Division | Quotient | MOD | Mod/Div |
---|---|---|---|---|---|
2.10 | 0.50 | 4.20 | 4 | 0.10 | 0.20 |
2.10 | 1.60 | 1.31 | 1 | 0.50 | 0.31 |
2.10 | 2.70 | 0.78 | 0 | 2.10 | 0.78 |
0.50 | 0.50 | 1.00 | 1 | 0.00 | 0.00 |
0.50 | 1.60 | 0.31 | 0 | 0.50 | 0.31 |
0.50 | 2.70 | 0.19 | 0 | 0.50 | 0.19 |
Related articles
Learn more about MOD in the following articles:
-
Applying color banding by document number in Power BI
This article describes how to use conditional formatting with a DAX expression to color the rows of a table in Power BI based on the order number instead of using the alternate rows color formatting option. » Read more
Related functions
Other related functions are:
Last update: Dec 4, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/mod-function-dax