DAX Function Guide
GCD
Sam McKay
CEO & Founder
How does the GCD work?
The GCD function (DAX) returns the two or more integers largest common divisor. The most common divisor is the largest integer dividing both number1 and number2 without a residual.
GCD Formula Syntax
GCD(number1, [number2], …)
How do you use the GCD?
If any argument is nonnumeric, GCD returns the #VALUE! error value.
If any argument is less than zero, GCD returns the #NUM! error value.
Related Blog Posts
Loading
Considerations when using the GCD?
One divides any value evenly.
A prime number has only itself and one as even divisors.
If a parameter to GCD is >=2^53, GCD returns the #NUM! error value.
Related Video Tutorials
Loading
Formula examples using the GCD
=GCD(24,36)
Related Courses
Loading