Splitting and merging columns in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does splitting a column mean in Power BI?

Splitting a column means breaking one column into two or more columns based on a delimiter or position. For example, splitting a full name into first and last names.

beginner

How can you merge columns in Power BI?

You can merge columns by selecting two or more columns and combining their values into one column, often with a separator like a space or comma.

beginner

Which Power BI feature helps you split columns easily without writing code?

The Power Query Editor has a 'Split Column' option that lets you split columns by delimiter, number of characters, or positions with a few clicks.

beginner

What is a common delimiter used when splitting columns?

Common delimiters include spaces, commas, semicolons, or special characters like hyphens. For example, splitting 'John Doe' by space gives 'John' and 'Doe'.

beginner

Why would you merge columns in a report?

Merging columns helps create a single combined value for easier reading or analysis, like combining first and last names into a full name.

Which Power BI tool lets you split columns without writing code?

A Power Query Editor

B DAX formula bar

C Report view

D Data view

Power Query Editor provides easy options to split columns by delimiter or position.

What happens when you merge two columns in Power BI?

A They create a new column combining both values

B One column deletes the other

C Columns are split into smaller parts

D Data types change automatically

Merging columns combines their values into a new single column.

Which delimiter would you use to split 'apple,banana,orange' into separate columns?

A Space

B Semicolon

C Hyphen

D Comma

The comma is the delimiter separating the fruits.

If you want to split a column by the first 3 characters, which method would you use?

A Split by delimiter

B Split by number of characters

C Merge columns

D Filter rows

Splitting by number of characters breaks the column at a fixed length.

What is a reason to split a column in your data?

A To delete unwanted data

B To combine multiple columns

C To separate combined data into parts

D To change data types

Splitting helps separate combined data like full names into first and last names.

Explain how you would split a full name column into first and last names in Power BI.

Think about how names are separated by spaces.

Describe the steps to merge two columns into one with a space separator in Power BI.

Merging combines values with a chosen separator.