What will be the output of CLEAN("Hello\nWorld") in Power BI?

medium📝 dax lod result Q5 of 15

Power BI - Data Cleaning with Power Query

What will be the output of CLEAN("Hello\nWorld") in Power BI?

A"HelloWorld"

B"Hello\nWorld"

C"Hello World"

D"Hello World"

Step-by-Step Solution

Solution:

Step 1: Understand CLEAN function
CLEAN removes non-printable characters like line breaks (\n) from text.
Step 2: Apply to input
Input has a line break; CLEAN removes it, resulting in "HelloWorld".
Final Answer:
"HelloWorld" -> Option A
Quick Check:
CLEAN function = Remove non-printable chars [OK]

Quick Trick: CLEAN removes line breaks and other non-printable chars [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