Recall & Review
beginner
What is DAX?
DAX stands for Data Analysis Expressions. It is a formula language used in Power BI to create custom calculations and measures.
Click to reveal answer
beginner
How do you add two columns in DAX?
You use the plus sign (+) to add two columns or values. For example:
Total Sales = Sales[Price] + Sales[Tax].Click to reveal answer
beginner
Which symbol is used for multiplication in DAX?
The asterisk (*) is used for multiplication. For example:
Total Cost = Sales[Quantity] * Sales[UnitPrice].Click to reveal answer
intermediate
What happens if you divide by zero in DAX?
Dividing by zero causes an error. To avoid this, use functions like
DIVIDE() which safely handle division by zero.Click to reveal answer
beginner
Write a DAX formula to calculate the difference between two columns: Sales[Revenue] and Sales[Cost].
You can write:
Profit = Sales[Revenue] - Sales[Cost]. This subtracts Cost from Revenue to get Profit.Click to reveal answer
Which symbol is used for subtraction in DAX?
✗ Incorrect
The minus sign (-) is used for subtraction in DAX.
What does this DAX expression do?
Total = Sales[Price] * Sales[Quantity]✗ Incorrect
The asterisk (*) multiplies Price by Quantity.
How can you safely divide two columns in DAX to avoid errors?
✗ Incorrect
DIVIDE() handles division by zero safely.
What is the result of
5 + 3 * 2 in DAX?✗ Incorrect
Multiplication has higher priority, so 3*2=6, then 5+6=11.
Which of these is NOT a basic arithmetic operator in DAX?
✗ Incorrect
The percent sign (%) is not a basic arithmetic operator in DAX.
Explain how to perform basic arithmetic operations in DAX with examples.
Think about how you add or multiply numbers in math class.
You got /3 concepts.
Describe how to handle division by zero errors in DAX calculations.
Consider what happens if you try to divide by zero on a calculator.
You got /3 concepts.