Given the text value " Hello World " in a column, what will be the result of TRIM(CLEAN([Column]))?

medium📝 dax lod result Q13 of 15

Power BI - Data Cleaning with Power Query

Given the text value " Hello World " in a column, what will be the result of TRIM(CLEAN([Column]))?

A"Hello World"

B" Hello World "

C"Hello\u0007 World"

D"HelloWorld"

Step-by-Step Solution

Solution:

Step 1: Apply CLEAN to remove non-printable characters
CLEAN removes the hidden character \u0007, so text becomes " Hello World ".
Step 2: Apply TRIM to remove extra spaces
TRIM removes spaces at start and end, resulting in "Hello World" with a single space between words.
Final Answer:
"Hello World" -> Option A
Quick Check:
TRIM + CLEAN cleans spaces and hidden chars = A [OK]

Quick Trick: CLEAN first removes hidden chars, then TRIM removes spaces [OK]

Common Mistakes:

Master "Data Cleaning with Power Query" in Power BI

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More Power BI Quizzes