LCM DAX Function (Math and Trig)

Syntax  |  Return values  |  Examples  

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

LCM ( <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.

Returns the least common multiple of integers.

Examples

1 2 3 4 5 6 7 8 9 10 11 12

--  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]

 Try it Copy

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 15, 2025   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

Microsoft documentation: https://docs.microsoft.com/en-us/dax/lcm-function-dax