- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
DAX Math & Trigonometric - DIVIDE function
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