Power BI - Data Cleaning with Power Query
Which of the following is the correct syntax to trim spaces from a column named
CustomerName in Power BI DAX?Which of the following is the correct syntax to trim spaces from a column named CustomerName in Power BI DAX?
easy📝 Conceptual Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Recall DAX function syntax
Functions use parentheses with column names inside, e.g., TRIM([ColumnName]).Step 2: Evaluate options
TRIM([CustomerName]) uses correct syntax; others use invalid brackets or missing parentheses.Final Answer:
TRIM([CustomerName]) -> Option DQuick Check:
Correct DAX syntax = TRIM(Column) [OK]
Quick Trick: Functions always use parentheses around column names [OK]
Common Mistakes:
- Using square or curly brackets incorrectly
- Omitting parentheses
- Confusing syntax with Excel formulas
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