DIVIDE Function (DAX)
Performs division and returns alternate result or BLANK() on division by 0.
Syntax
DIVIDE(<numerator>, <denominator> [,<alternateresult>])
Parameters
Term |
Definition |
---|---|
numerator |
The dividend or number to divide. |
denominator |
The divisor or number to divide by. |
alternateresult |
(Optional) The value returned when division by zero results in an error. When not provided, the default value is BLANK(). |
Return Value
A decimal number.
Remarks
Alternate result on divide by 0 must be a constant.
Example
The following example returns 2.5.
=DIVIDE(5,2)
The following example returns BLANK.
=DIVIDE(5,0)
The following example returns 1.
=DIVIDE(5,0,1)