Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Etc.
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?
Thanks!
hi, @Anonymous
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?
Best Regards,
Lin
Hi Lin,
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |