[Solved] You wrote this DAX measure:Measure = IF(Sales[Amount] = BLANK(), 0, Sales[Amount])But it returns an error. What is the problem? | Power BI

Power BI - Data Cleaning with Power Query

You wrote this DAX measure:

Measure = IF(Sales[Amount] = BLANK(), 0, Sales[Amount])

But it returns an error. What is the problem?

AYou cannot compare a column directly to BLANK()

BBLANK() is not a valid DAX function

CYou must use ISBLANK() to check for blank values

DThe syntax is correct; error is elsewhere

Step-by-Step Solution

Solution:

Step 1: Understand blank value checking in DAX
Direct comparison with BLANK() is invalid; use ISBLANK() function instead.
Step 2: Correct the measure
Use IF(ISBLANK(Sales[Amount]), 0, Sales[Amount]) to avoid error.
Final Answer:
You must use ISBLANK() to check for blank values -> Option C
Quick Check:
Use ISBLANK() to check blanks [OK]

Quick Trick: Use ISBLANK() to test blanks, not = BLANK() [OK]

Common Mistakes:

Master "Data Cleaning with Power Query" in Power BI

9 interactive learning modes - each teaches the same concept differently

More Power BI Quizzes

You wrote this DAX measure: