A user wrote this Power Query step: Table.SplitColumn(Source, "Name", Splitter.SplitTextByDelimiter("-"), {"First", "Last"}). It returns an error. What is the problem?

medium📝 Formula Fix Q7 of 15

Power BI - Power Query Editor

AThe column 'Name' does not exist in Source

BSplitter.SplitTextByDelimiter requires a space, not a dash

CTable.SplitColumn is not a valid function

DThe output column names must be numeric

Step-by-Step Solution

Solution:

Step 1: Check function and parameters
Table.SplitColumn is valid; delimiter can be any character; output names can be strings.
Step 2: Identify cause of error
If 'Name' column is missing in Source table, the function errors.
Final Answer:
The column 'Name' does not exist in Source -> Option A
Quick Check:
Missing column causes split error [OK]

Quick Trick: Verify column exists before splitting [OK]

Common Mistakes:

Assuming function is invalid
Thinking delimiter must be space
Believing output names must be numbers

Master "Power Query Editor" in Power BI

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Sheet Try Challenge Scenario Recall Dash

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

More Power BI Quizzes

A user wrote this Power Query step: Table.SplitColumn(Source, "Name", Splitter.SplitTextByDelimiter("-"), {"First", "Last"}). It returns an error. What is the problem?

Step 1: Check function and parameters

Step 2: Identify cause of error

Final Answer:

Quick Check:

Want More Practice?