You’re offline. This is a read only version of the page.
4
Hi everybody,
I'm new in Power BI and I have to use Power query to check if a custom function returns successfully or not.
I have some addresses, and I call a Bing maps function to get latitude and longitude coordinates. Sometimes this function fail because address has wrong format.
I would like to know which address is ok and which is wron, with error or success in a column to indicate the result of the search.
Here is the formula to add latitude and longitude columns (it works) :
= Table.ExpandTableColumn(Table.AddColumn(#"Colonne fusionnée insérée", "LatitudeLongitude", each try fxPointLookup(Text.Trim(Text.Replace([Address], "&", " and "))) otherwise
try fxPointLookup(Text.Trim(Text.Replace([City], "&", " and "))) otherwise fxPointLookup(Text.Trim(Text.Replace([COUNTRY], "&", " and "))) ), "LatitudeLongitude", {"Latitude", "Longitude"}, {"Latitude", "Longitude"})
So, now, I would like to add a new column, called "Error", to display "True" if the fxPointLookup call (fxPointLookup(Text.Trim(Text.Replace([Address], "&", " and ")))) failed and "False" if not.
Could you help me to do this please ?
I don't know how to get the "success" case, or a default case 😢
Hi,
Here is a PowerBI file with sample.
You have to set a Bing Maps API Dev Key in fxPointLookup function (key="YourAPIKey").
In ADDRESS table, column ERROR is a sample of the result I want to obtain dynamically, with the success or fail of calling to fxPointLookup. If fxPointLookup returns some coordinates, I want FALSE. If not (Error of function), I want TRUE.
Thanks for your help 🙂
#1
mmbr1606
9
Super User 2025 Season 1
#2
stampcoin
7
#3
SD-13050734-0
6
Share
Report
All responses (
Answers (
