DAX Math & Trigonometric - DIVIDE function
Advertisements
Description
Performs division and returns alternate result or BLANK () on division by 0.
Syntax
DIVIDE (<numerator>, <denominator>, [<alternateresult>])
Parameters
Sr.No. | Parameter & Description |
---|---|
1 |
numerator The dividend or the number to divide. |
2 |
denominator The divisor or the number to divide by. |
3 |
alternateresult Optional. The value returned when division by zero results in an error. If omitted, the default value is BLANK (). |
Return Value
A decimal number or BLANK ().
Remarks
alternateresult on ‘divide by 0’ must be a constant.
Example
= DIVIDE (5,0,"Div by zero Error") returns Div by zero Error. = DIVIDE (5,0) returns (blank). = DIVIDE (5,4) returns 1.25.
dax_functions_mathematical_trigonometric.htm
Advertisements