Which of the following is the correct way to merge two columns FirstName and LastName with a space separator in Power Query?

easy📝 Formula Fix Q12 of 15

Power BI - Power Query Editor

Which of the following is the correct way to merge two columns FirstName and LastName with a space separator in Power Query?

ATable.RemoveColumns(Source, {"FirstName", "LastName"})

BTable.SplitColumn(Source, "FullName", Splitter.SplitTextByDelimiter(" "))

CTable.AddColumn(Source, "FullName", each [FirstName] & " " & [LastName])

DTable.TransformColumnTypes(Source, {"FullName", type text})

Step-by-Step Solution

Solution:

Step 1: Identify merging syntax in Power Query
Merging columns uses Table.AddColumn with an expression combining columns using & and a separator.
Step 2: Check each option
Table.AddColumn(Source, "FullName", each [FirstName] & " " & [LastName]) correctly concatenates FirstName and LastName with a space. Table.RemoveColumns removes columns, Table.SplitColumn splits columns, Table.TransformColumnTypes changes data types.
Final Answer:
Table.AddColumn(Source, "FullName", each [FirstName] & " " & [LastName]) -> Option C
Quick Check:
Merge = AddColumn with & [OK]

Quick Trick: Use & with space inside AddColumn to merge columns [OK]

Common Mistakes:

Master "Power Query Editor" in Power BI

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More Power BI Quizzes