Notifications
Clear all
Power BI
2
Posts
2
Users
0
Reactions
104
Views
Topic starter
Hey All,
if you could please help me in below, I have got different cities across globe when i try to put into maps Perth, WA shows in North America. i tried to fix this from one of the videos from Mynda but not getting 100 % correct.
following formula does not work for multiple countries and cities.
City, Country = Location[Location]&", Australia"
Appreciate your help
Thanks
Amit
Posted : 17/08/2023 12:05 am
Hi Amit,
If you have multiple countries in your dataset, then you should have a country column. In which case you can merge the city or state and country columns together to create an unambiguous location. e.g.:
= Location[City] & ", "& Location[Country]
Mynda
Posted : 17/08/2023 8:20 pm
