cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
andywil456 Regular Visitor
Regular Visitor

combine City and Country fields into one field

I'm trying to do a map visual based on UK towns. The problem is certain towns are classed as US or Australian.

I have read the best way to resolve this is to combine my Towns and Country field into one column. for Example Newcastle, UK. 

How do I merger/combine two columns within the same table and put in a comma to seperate? 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: combine City and Country fields into one field

In the query-editor:

Check both columns -> Add Column -> From Text -> Merge Columns -> select "Comma" in the Merge Columns-dialogue

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




1 REPLY 1
Super User
Super User

Re: combine City and Country fields into one field

In the query-editor:

Check both columns -> Add Column -> From Text -> Merge Columns -> select "Comma" in the Merge Columns-dialogue

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries