Power BI - Data Cleaning with Power Query
Which of the following is the correct syntax to remove non-printable characters from a column named
Comments in Power BI?Which of the following is the correct syntax to remove non-printable characters from a column named Comments in Power BI?
easy📝 Formula Fix Q12 of 15
Step-by-Step Solution
Solution:
Step 1: Identify the function for non-printable characters
The CLEAN function removes hidden non-printable characters from text.Step 2: Verify syntax correctness
CLEAN(Comments) is the correct syntax; TRIM removes spaces, REMOVE and STRIP are invalid in Power BI.Final Answer:
CLEAN(Comments) -> Option DQuick Check:
CLEAN removes non-printable chars = C [OK]
Quick Trick: Use CLEAN to remove hidden characters, TRIM for spaces [OK]
Common Mistakes:
- Using TRIM instead of CLEAN for hidden characters
- Trying non-existent functions like REMOVE or STRIP
- Confusing syntax with other languages
Master "Data Cleaning with Power Query" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes