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 integers.
Remarks
GCD accepts only two arguments. To get the greatest common divisor of more than two numbers, use nested calls. For example, GCD ( GCD ( 12, 18 ), 8 ) returns 2.
Examples
-- GCD - Returns the greatest common divisor of two integers
-- LCM - Returns the least common multiple of two 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 |
Related functions
Other related functions are:
Last update: Oct 28, 2026 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber
Microsoft documentation: https://docs.microsoft.com/en-us/dax/gcd-function-dax