You have a column Feedback with messy text containing extra spaces and hidden characters. Which DAX formula correctly cleans and trims the text for a new calculated column?

hard📝 Scenario Q15 of 15

Power BI - Data Cleaning with Power Query

You have a column Feedback with messy text containing extra spaces and hidden characters. Which DAX formula correctly cleans and trims the text for a new calculated column?

ACleanTrim = TRIM([Feedback]) + CLEAN([Feedback])

BCleanTrim = CLEAN(TRIM([Feedback]))

CCleanTrim = TRIM(CLEAN([Feedback]))

DCleanTrim = SUBSTITUTE(TRIM([Feedback]), CLEAN([Feedback]), "")

Step-by-Step Solution

Solution:

Step 1: Understand order of operations
CLEAN should be applied first to remove hidden characters, then TRIM removes extra spaces.
Step 2: Evaluate each option
CleanTrim = TRIM(CLEAN([Feedback])) applies CLEAN then TRIM correctly. CleanTrim = CLEAN(TRIM([Feedback])) reverses order, which may leave hidden chars. Options C and D misuse functions and produce incorrect results.
Final Answer:
CleanTrim = TRIM(CLEAN([Feedback])) -> Option C
Quick Check:
CLEAN then TRIM cleans text best = A [OK]

Quick Trick: Always CLEAN first, then TRIM for best text cleaning [OK]

Common Mistakes:

Applying TRIM before CLEAN
Adding results instead of nesting functions
Using SUBSTITUTE incorrectly to clean text

Master "Data Cleaning with Power Query" in Power BI

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Sheet Try Challenge Scenario Recall Dash

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

More Power BI Quizzes

You have a column Feedback with messy text containing extra spaces and hidden characters. Which DAX formula correctly cleans and trims the text for a new calculated column?

Step 1: Understand order of operations

Step 2: Evaluate each option

Final Answer:

Quick Check:

Want More Practice?