Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
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 biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today