DAX Math & Trigonometric - GCD function

Description

Returns the greatest common divisor of two integers.

DAX GCD function is new in Excel 2016.

Syntax

GCD (<number1>, <number2>) 

Parameters

Return Value

A positive integer.

Remarks

The greatest common divisor is the largest integer that divides both number1 and number2 without a remainder.

• If any of the parameters is not an integer, it will be rounded.

• If any of the parameters is negative, the function returns error.

• If any of the parameters is non-numeric, the function returns error.

• If the parameters do not have a common divisor > 1, the function returns 1.

Example

= GCD (16,20) returns 4. 
= GCD (15,25) returns 5.