Power BI - Data Cleaning with Power Query
Which DAX function is best to replace blank values with a specific number in Power BI?
Which DAX function is best to replace blank values with a specific number in Power BI?
easy📝 Conceptual Q2 of 15
Step-by-Step Solution
Solution:
Step 1: Identify function to handle blanks
COALESCE() returns the first non-blank value, useful to replace blanks with a default.Step 2: Compare with other options
ISBLANK() checks for blanks but does not replace; IFBLANK() and REPLACEBLANK() do not exist in DAX.Final Answer:
COALESCE() is best to replace blank values -> Option BQuick Check:
Replace blanks = COALESCE() [OK]
Quick Trick: Use COALESCE() to replace blanks with defaults [OK]
Common Mistakes:
- Using ISBLANK() to replace values instead of check
- Assuming IFBLANK() exists
- Trying to use REPLACEBLANK() which is not a DAX function
Master "Data Cleaning with Power Query" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes