Splitting and merging columns in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to split the 'FullName' column into first and last names using Power Query.

Power BI

Table.SplitColumn(Source, "FullName", Splitter.SplitTextByDelimiter(" ", [1]), {"FirstName", "LastName"})

Drag options to blanks, or click blank then click option'

AQuoteStyle.Csv

BQuoteStyle.None

CQuoteStyle.Text

DQuoteStyle.Ignore

Attempts:

3 left

💡 Hint

Common Mistakes

Using QuoteStyle.Csv causes unexpected splits if quotes are present.

Forgetting to specify the quote style leads to errors.

Using QuoteStyle.None ensures the split happens exactly at the delimiter without considering quotes.

2fill in blank

medium

Complete the code to merge 'City' and 'Country' columns with a comma separator in Power Query.

Power BI

Table.CombineColumns(Source, {"City", "Country"}, Combiner.CombineTextByDelimiter([1], QuoteStyle.None), "Location")

Drag options to blanks, or click blank then click option'

A;

B,

C -

D /

Attempts:

3 left

💡 Hint

Common Mistakes

Using semicolon or dash instead of comma can confuse users.

Not including a space after the comma makes the text harder to read.

The comma and space ", " is a common separator for city and country names.

3fill in blank

hard

Fix the error in this Power Query code to split 'DateTime' into 'Date' and 'Time' columns.

Power BI

Table.SplitColumn(Source, "DateTime", Splitter.SplitTextByEachDelimiter({"[1]"}, false, [2]), {"Date", "Time"})

Drag options to blanks, or click blank then click option'

AT

Bt

C" "

D:

Attempts:

3 left

💡 Hint

Common Mistakes

Using lowercase 't' instead of uppercase 'T' causes no split.

Using space or colon as delimiter does not match the datetime format.

The delimiter between date and time in ISO format is uppercase 'T'.

4fill in blank

hard

Fill both blanks to merge 'FirstName' and 'LastName' with a space separator and no quotes in Power Query.

Power BI

Table.CombineColumns(Source, {"FirstName", "LastName"}, Combiner.CombineTextByDelimiter([1], [2]), "FullName")

Drag options to blanks, or click blank then click option'

A" "

BQuoteStyle.None

CQuoteStyle.Csv

D"-"

Attempts:

3 left

💡 Hint

Common Mistakes

Using dash instead of space changes the name format.

Using QuoteStyle.Csv adds unwanted quotes around names.

Use a space " " as delimiter and QuoteStyle.None to avoid adding quotes.

5fill in blank

hard

Fill all three blanks to split 'Address' by comma, trim spaces, and keep both parts in Power Query.

Power BI

Table.TransformColumns(Table.SplitColumn(Source, "Address", Splitter.SplitTextByDelimiter([1], [2]), {"Street", "City"}), {{"Street", Text.Trim}, {"City", [3])

Drag options to blanks, or click blank then click option'

A","

BQuoteStyle.None

CText.Trim

DQuoteStyle.Csv

Attempts:

3 left

💡 Hint

Common Mistakes

Using QuoteStyle.Csv adds quotes around parts.

Not trimming spaces leaves unwanted whitespace.

Split by comma "," with no quotes, then trim spaces from both parts.