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.
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(
Table B:
SITE ID CI128 HXL = SUMMARIZECOLUMNS('A'[X])
measure to calculate distance :
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
Hey,
please provide a pbix file that contains some sample data, but still represents the data model, upload the file to onderive, dropbox, and share the link (if you use xlsx for the data creation, upload the xlsx file as well).
Regards,
Tom
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |