Recall & Review
beginner
What does the DIVIDE function do in Power BI?
DIVIDE performs division safely by handling cases where the denominator might be zero or blank, preventing errors.
Click to reveal answer
beginner
Syntax of DIVIDE function in Power BI?
DIVIDE(<numerator>, <denominator>, [alternateResult]) where alternateResult is optional and returned if denominator is zero or blank.
Click to reveal answer
beginner
Why use DIVIDE instead of '/' operator in DAX?
DIVIDE avoids errors from division by zero or blank values by returning an alternate result instead of an error.
Click to reveal answer
beginner
Example: What is the result of DIVIDE(10, 0, 0)?
The result is 0 because the denominator is zero and the alternateResult 0 is returned safely.
Click to reveal answer
intermediate
What happens if you omit the alternateResult in DIVIDE and denominator is zero?
DIVIDE returns blank instead of an error when denominator is zero and alternateResult is omitted.
Click to reveal answer
What does DIVIDE(15, 3) return?
✗ Incorrect
15 divided by 3 equals 5, so DIVIDE returns 5.
What result does DIVIDE(10, 0, 1) produce?
✗ Incorrect
Since denominator is zero, DIVIDE returns the alternateResult 1.
If denominator is blank and alternateResult is not provided, DIVIDE returns:
✗ Incorrect
DIVIDE returns blank when denominator is zero or blank and no alternateResult is given.
Why is DIVIDE preferred over '/' operator in DAX?
✗ Incorrect
DIVIDE safely handles division by zero or blank denominator to avoid errors.
What is the correct syntax for DIVIDE?
✗ Incorrect
DIVIDE takes numerator, denominator, and optional alternateResult in that order.
Explain how DIVIDE helps prevent errors in Power BI calculations.
Think about what happens when you divide by zero.
You got /3 concepts.
Describe the syntax and usage of the DIVIDE function with an example.
Focus on the parameters and what happens if denominator is zero.
You got /3 concepts.