Forum Discussion
Rank based on distance measure
I have three tables which i am using in order to calculate the distance between two lat/longs. Table A : X, lat , long Table " From A" : From A = SUMMARIZECOLUMNS( 'A'[X], 'A'[LATITU...
Tom,
Thankyou for the response .
Here’s the complete details on data structure
Table A :
LONGITUDE | LATITUDE | X |
-96.6 | 32.9 | A |
-96.9 | 33 | B |
-96.5 | 32 | C |
-97.7 | 31 | D |
-96 | 32.2 | A |
-97 | 32.1 | B |
-96.5 | 33 | E |
-97.7 | 31 | X |
Table B = SUMMARIZECOLUMNS('A'[X])
From A = SUMMARIZECOLUMNS(
'A'[X],
'A'[LATITUDE],
'A'[LONGITUDE]
)
OUTPUT TABLE :
X (coming from table A) | X(Coming from table From A) | Distance(miles) |
A | C | 14.99815 |
C | A | 14.99815 |
A | B | 24.38354 |
B | A | 24.38354 |
Now I need to rank column [ X(Coming from table From A) ] based on values in column " distance(miles)" .
Hope this explains the query in details..
Thankyou
Tanvi