Finding all inputs and displaying the distance based on long and lat

[siros92]

Hi Everybody! 

Previously this forum has given me so much help. However, now i'm going to ask for some more, and I think it's a complicated one I've gotten stuck with. 

I've run into an issue in my list of salmon farms. Basicly, I want to based on Longitude and Latitude find all farms within 200 km whenever there is a process ongoing on one of the previously tagged farms. 

So, lon and lat is relatively self explanatory. The next cells until "annet virkestoff ID" is not important here. 

The collumn "Annet virkestoff ID" is a collumn used to tag events at farms. So if this is triggered, i want all farms in within 200 km to be tagged, so i can withdraw the data, filtered by week. I've allready calculated the distance from a 0 point in the "Distance_km from 0.0" collumn. 

Any ideas for next steps? 

Cheers, 

[v-piga-msft]

Hi @siros92 ,

I still have a little confused about your requirement.

If it is convenient, could you share the data sample which could reproduce your scenario and your desired output so that we could help further on it.

Best Regards,

Cherry