Map with a measure - CONCATEX function

[jlandsm4785]

Hello,

Does anyone know the best way to concate / combine address information to create a full address to be used on the map visualization? The data that i am using has address, city, and zip split into multiple columns so the map visualization has some incorrect points because its searching only using the street address. I tried using the CONCATEX function to bring the columns together but i could not use this measure as a location for the map visual . Any guidance is appreciated.

Thanks, 

[amitchandak · Accepted solution]

@jlandsm4785 , I think you need concat and create a column not measure

https://youtu.be/7ZCrCEicVNY

[jlandsm4785]

Hello,

Thank you for your input. In this instance my data source is coming from my orginzation in PowerBi service and when i use the desktop version it does not allow me to create a column. Do you know if there's any way around that?

Thanks again