LCM
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
Returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple of all integer arguments number1, number2, and so on. Use LCM to add fractions with different denominators.
Syntax
LCM(number1, [number2], ...)
Parameters
| Term | Definition |
|---|---|
| number1, number2,... | Number1 is required, subsequent numbers are optional. 1 to 255 values for which you want the least common multiple. If value is not an integer, it is truncated. |
Return value
Returns the least common multiple of integers.
Remarks
If any argument is nonnumeric, LCM returns the #VALUE! error value.
If any argument is less than zero, LCM returns the #NUM! error value.
If LCM(a,b) >=2^53, LCM returns the #NUM! error value.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Example
| Formula | Description | Result |
|---|---|---|
| = LCM(5, 2) | Least common multiple of 5 and 2. | 10 |
| = LCM(24, 36) | Least common multiple of 24 and 36. | 72 |