When people are selecting a location (which is text), I want this selected text to translate to a given Lat/Long for that location. There are around 90 locations, each with an indivudal lat/long.
Location Lat Long
1A1 13.456 16.765
2C4 13.765 18.435
3B5 17.463 16.453
So the input being received in the Location and each has a fixed Lat/Long, so how do i automatically convert that Location into the coordinates in the Lat/Long columns?
Since you have the Location and Lat/Long table, when you select a Location, the corresponding Lat/Long will appear automatically.
What is your expected output?
I don't think I explained it properly. I've created a form in PowerApps with a Location choice drop down menu, taken from a list in SharePoint. I want the associated lat/long for that location to be input automatically into two separate columns within Power BI. Am I able to directly link the lat/long with the associated location somehow? I can create separate tables for each if needed.