I have 2 virtual columns:
IFS(NOT(ISBLANK([Coordinates (Lat, Long)])),
TOP(
ORDERBY(
FILTER("No INACTIVE Status", TRUE),
DISTANCE(
[_THISROW].[Coordinates (Lat, Long)],
[Coordinates (Lat, Long)]
)
),
5
))
FILTER(
"UDB Datasource 1.0",
IN(
[PLA ID], [Top 5])
)
I want to add another column in the Nearest PLA ID table to indicate the exact distance between 2 locations.
Have you tried DISTANCE()? See the link to the documentation below.
User | Count |
---|---|
41 | |
25 | |
25 | |
17 | |
12 |