Bird
0
0

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:
  1. Step 1: Understand CLEAN function

    CLEAN removes non-printable characters like line breaks (\n) from text.
  2. Step 2: Apply to input

    Input has a line break; CLEAN removes it, resulting in "HelloWorld".
  3. Final Answer:

    "HelloWorld" -> Option A
  4. Quick Check:

    CLEAN function = Remove non-printable chars [OK]
Quick Trick: CLEAN removes line breaks and other non-printable chars [OK]
Common Mistakes:
  • Expecting line breaks to remain
  • Thinking CLEAN replaces with spaces
  • Confusing CLEAN with TRIM

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Power BI Quizzes