If you have a column EmployeeName with values like 'Alice Johnson', what will be the output after splitting this column by the space character in Power Query?
medium📝 dax lod result Q4 of 15
Power BI - Power Query Editor
If you have a column EmployeeName with values like 'Alice Johnson', what will be the output after splitting this column by the space character in Power Query?
ATwo new columns: 'EmployeeName.1' with 'Alice' and 'EmployeeName.2' with 'Johnson'
BA single column with the value unchanged as 'Alice Johnson'
CA column with values concatenated as 'AliceJohnson' without space
DAn error because splitting by space is not supported
Step-by-Step Solution
Solution:
Step 1: Identify delimiter
The space character is used as the delimiter to split the text.
Step 2: Apply split
Power Query splits the EmployeeName column into two columns, each containing the parts before and after the space.
Final Answer:
Two new columns: 'EmployeeName.1' with 'Alice' and 'EmployeeName.2' with 'Johnson' -> Option A
Quick Check:
Splitting by space creates multiple columns [OK]
Quick Trick:Splitting by space creates multiple columns [OK]
Common Mistakes:
Assuming the original column remains unchanged
Expecting concatenation instead of splitting
Thinking splitting by space causes an error
Master "Power Query Editor" in Power BI
9 interactive learning modes - each teaches the same concept differently
