Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: Calculated column Calculated table Measure Visual calculation
Performs division and returns alternate result or BLANK() on division by 0.
DIVIDE(<numerator>, <denominator> [,<alternateresult>])
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(). |
Alternate result on divide by 0 must be a constant.
For best practices when using DIVIDE, see DIVIDE function vs. divide operator (/) in DAX.
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)
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register today