Power BI - Data Cleaning with Power Query
Which of the following DAX expressions correctly checks if a column 'Sales' is blank?
Which of the following DAX expressions correctly checks if a column 'Sales' is blank?
easy📝 Conceptual Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Identify correct DAX function to check blank
ISBLANK() is the correct function to check if a value is blank in DAX.Step 2: Evaluate other options
Sales = BLANK() is invalid syntax; NULL and ISNULL() are not valid in DAX.Final Answer:
ISBLANK(Sales) correctly checks for blank -> Option CQuick Check:
Check blank = ISBLANK() [OK]
Quick Trick: Use ISBLANK() to test for blanks in DAX [OK]
Common Mistakes:
- Using NULL or ISNULL() which are not DAX functions
- Trying to compare directly with BLANK() using =
- Confusing blank check with zero check
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