DIVIDE
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.
For best practices when using DIVIDE, see DIVIDE function vs. divide operator (/) in DAX.
Example
The following example returns 2.5.
= DIVIDE(5,2)
Example 1
The following example returns BLANK.
= DIVIDE(5,0)
Example 2
The following example returns 1.
= DIVIDE(5,0,1)
Related content
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for