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
GCD ( <Number1>, <Number2> )
| 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
Scalar A single integer value.
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: Apr 11, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/gcd-function-dax
2018-2024 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies