GCD DAX Function (Math and Trig)
Returns the greatest common divisor of two integers. The greatest common divisor is the largest integer that divides both number1 and number2 without a remainder.
Syntax
Parameter | Attributes | Description |
---|---|---|
Number1 |
The first number, if value is not an integer, it is truncated. |
|
Number2 |
The second number, if value is not an integer, it is truncated. |
Return values
The greatest common divisor of two or more integers.
Examples
-- GCD - Returns the greatest common divisor of two or more integers -- LCM - Returns the least common multiple of integers DEFINE VAR Val1 = SELECTCOLUMNS ( GENERATESERIES ( 6, 25, 7 ), "Val1", [Value] ) VAR Val2 = SELECTCOLUMNS ( GENERATESERIES ( 2, 3, 1 ), "Val2", [Value] ) EVALUATE ADDCOLUMNS ( CROSSJOIN ( Val1, Val2 ), "GCD", GCD ( [Val1], [Val2] ), "LCM", LCM ( [Val1], [Val2] ) ) ORDER BY [Val1], [Val2]
Val1 | Val2 | GCD | LCM |
---|---|---|---|
6 | 2 | 2 | 6 |
6 | 3 | 3 | 6 |
13 | 2 | 1 | 26 |
13 | 3 | 1 | 39 |
20 | 2 | 2 | 20 |
20 | 3 | 1 | 60 |
Last update: Dec 4, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/gcd-function-dax