LCM DAX Function (Math and Trig)
Returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple of both integer arguments number1, number2. Use LCM to add fractions with different denominators.
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
Returns the least common multiple of integers.
Remarks
LCM accepts only two arguments. To get the least common multiple of more than two numbers, use nested calls. For example, LCM ( LCM ( 4, 6 ), 10 ) returns 60.
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: Nov 9, 2026 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber
Microsoft documentation: https://docs.microsoft.com/en-us/dax/lcm-function-dax