[Solved] What will the following DAX expression return?Result = COALESCE(MAX(Sales[Amount]), 100)If the 'Sales[Amount]' column contains only blank values? | Power BI

Power BI - Data Cleaning with Power Query

What will the following DAX expression return?

Result = COALESCE(MAX(Sales[Amount]), 100)

If the 'Sales[Amount]' column contains only blank values?

ABlank

B0

CError

D100

Step-by-Step Solution

Solution:

Step 1: Evaluate MAX of blank values
MAX of blank values returns blank in DAX.
Step 2: Apply COALESCE function
COALESCE returns first non-blank, so returns 100.
Final Answer:
The expression returns 100 -> Option D
Quick Check:
COALESCE replaces blank with 100 = 100 [OK]

Quick Trick: COALESCE returns first non-blank value [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

What will the following DAX expression return?