Power BI - Formatting and Design
You wrote this DAX formula for conditional formatting: IF(Sales > 1000, "Green", "Red". Why does it cause an error?
You wrote this DAX formula for conditional formatting: IF(Sales > 1000, "Green", "Red". Why does it cause an error?
medium📝 Formula Fix Q6 of 15
Step-by-Step Solution
Solution:
Step 1: Check the DAX formula syntax
The formula IF(Sales > 1000, "Green", "Red" is missing a closing parenthesis at the end.Step 2: Identify the syntax error
Without the closing parenthesis, the formula is incomplete and causes an error.Final Answer:
Missing closing parenthesis -> Option CQuick Check:
Syntax error = Missing parenthesis [OK]
Quick Trick: Always count opening and closing parentheses [OK]
Common Mistakes:
- Forgetting to close parentheses
- Using wrong function names
- Assuming color names cause errors
Master "Formatting and Design" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes