You have a column Location with values like '456 Elm St; Denver; CO'. How can you split this column into Street, City, and State in Power Query?

hard📝 Scenario Q8 of 15

Power BI - Power Query Editor

You have a column Location with values like '456 Elm St; Denver; CO'. How can you split this column into Street, City, and State in Power Query?

AUse <code>Merge Columns</code> with semicolon (;) as the separator

BUse <code>Split Column by Delimiter</code> with semicolon (;) as the delimiter and specify splitting into three columns

CReplace semicolons with commas and then split by comma delimiter

DUse <code>Split Column by Number of Characters</code> with 3 characters

Step-by-Step Solution

Solution:

Step 1: Identify delimiter
The semicolon (;) separates the parts of the address.
Step 2: Use Split Column by Delimiter
In Power Query, select the Location column and choose to split by delimiter ';' and specify splitting into three columns.
Final Answer:
Use Split Column by Delimiter with semicolon (;) as delimiter -> Option B
Quick Check:
Splitting by correct delimiter separates address parts [OK]

Quick Trick: Split by correct delimiter to separate address parts [OK]

Common Mistakes:

Using merge instead of split
Splitting by wrong delimiter like comma
Splitting by fixed number of characters causing incorrect splits

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

You have a column Location with values like '456 Elm St; Denver; CO'. How can you split this column into Street, City, and State in Power Query?

Step 1: Identify delimiter

Step 2: Use Split Column by Delimiter

Final Answer:

Quick Check:

Want More Practice?