LCM Function (DAX)

How does the LCM function (DAX) work?

The LCM function (DAX) returns the least common integer number. The least common multiple is the smallest positive integer, which is a multiple of all number1, number2, and so forth integer arguments. Using LCM to add different-denominator fractions.

LCM Formula Syntax

     number1, [number2], …

How do you use the LCM function?

Use LCM to add different denominators to fractions.

Related Blog Posts

Related Support Forum Posts

Understanding DAX Formula
Developing Complex Dax functions

Considerations when using the LCM function

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.

Related Video Tutorials


Formula examples using the LCM function

=LCM(5, 2)

Least common multiple of 5 and 2
Result: 10

=LCM(24, 36)

Least common multiple of 24 and 36
Result: 72

Related Course Modules

Center of Excellence


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.

Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide