[Solved] You tried to merge columns City and Country using this code:Table.AddColumn(Source, "Location", each [City] + ", " + [Country])But you get an error. What is the likely cause? | Power BI

Power BI - Power Query Editor

You tried to merge columns City and Country using this code:

Table.AddColumn(Source, "Location", each [City] + ", " + [Country])

But you get an error. What is the likely cause?

AMissing a space after the comma separator

BUsing + operator instead of & for text concatenation

CTable.AddColumn cannot merge columns

DColumn names are case sensitive and incorrect

Step-by-Step Solution

Solution:

Step 1: Check concatenation operator in Power Query
Power Query uses & to join text, not + which causes an error.
Step 2: Review other options
Missing space after comma is not an error, AddColumn can merge columns, and case sensitivity depends on source but usually not error here.
Final Answer:
Using + operator instead of & for text concatenation -> Option B
Quick Check:
Use & for text join, not + [OK]

Quick Trick: Use & to join text columns, not + [OK]

Common Mistakes:

Master "Power Query Editor" in Power BI

9 interactive learning modes - each teaches the same concept differently

More Power BI Quizzes

You tried to merge columns City and Country using this code: