Bird
0
0

Why does the TRIM function not remove multiple spaces between words in Power BI?

hard📝 Conceptual Q10 of 15
Power BI - Data Cleaning with Power Query
Why does the TRIM function not remove multiple spaces between words in Power BI?
ABecause TRIM only removes spaces at the start and end of text
BBecause TRIM removes only non-printable characters
CBecause TRIM converts text to uppercase instead
DBecause TRIM replaces spaces with tabs
Step-by-Step Solution
Solution:

  1. Step 1: Understand TRIM's scope

    TRIM targets spaces only at the beginning and end of text strings.

  2. Step 2: Explain why inner spaces remain

    Spaces between words are not considered extra spaces at edges, so TRIM leaves them intact.

  3. Final Answer:

    Because TRIM only removes spaces at the start and end of text -> Option A

  4. Quick Check:

    TRIM affects edge spaces only [OK]
Quick Trick: TRIM never removes spaces inside text, only edges [OK]
Common Mistakes:
  • Thinking TRIM removes all spaces
  • Confusing TRIM with CLEAN
  • Assuming TRIM changes text case

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Power BI Quizzes
Basic Visualizations - Bar and column charts - Quiz 1easy Basic Visualizations - Why choosing the right visual matters - Quiz 1easy Basic Visualizations - Map visualizations - Quiz 9hard Data Cleaning with Power Query - Removing duplicates - Quiz 5medium Formatting and Design - Conditional formatting in tables - Quiz 10hard Formatting and Design - Title, labels, and legends - Quiz 1easy Getting Data - Why connecting to data sources is the first step - Quiz 3easy Power BI Basics and Architecture - Power BI workflow (get data, transform, visualize, share) - Quiz 12easy Power Query Editor - Power Query interface overview - Quiz 3easy Power Query Editor - Splitting and merging columns - Quiz 2easy