DAX Math & Trigonometric - GCD function


Advertisements

Description

Returns the greatest common divisor of two integers.

DAX GCD function is new in Excel 2016.

Syntax

GCD (<number1>, <number2>) 

Parameters

Sr.No. Parameter & Description
1

number1

A positive number.

2

number2

A positive number.

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. 
dax_functions_mathematical_trigonometric.htm

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements