DAX Math & Trigonometric - LCM function

Description

Returns the least common multiple of integers.

DAX LCM function is new in Excel 2016.

Syntax

LCM (<number1>, [<number2>] ...)

Parameters

Sr.No. Parameter & Description
1

number1, number2, …

number1 is required, subsequent numbers are optional - 1 to 255 values for which you want the least common multiple.

If the value is not an integer, it is truncated.

Return Value

An Integer.

Remarks

The least common multiple is the smallest positive integer that is a multiple of all integer arguments number1, number2, etc.

You can use LCM to add fractions with different denominators.

  • If any parameter is non-numeric, LCM returns error.
  • If any parameter is less than zero, LCM returns error.
  • If LCM (a, b) >= 2^53, LCM returns error.

Example

= LCM (2,4) returns 4. 
= LCM (5,3) returns 15.
dax_functions_mathematical_trigonometric.htm
Advertisements