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've not been able to get my distance calculation working. I'm following a solution on another post, but the only difference between this one and mine is that some of my coords are in another table so i am using RELATED. My code is:
Distance = ACOS(SIN('LB_Incident_Post1970'[Incident_Latitude])*
SIN(RELATED('GIS.LifeboatStations'[Stn_Latitude])+
COS('LB_Incident_Post1970'[Incident_Latitude])*
COS(RELATED('GIS.LifeboatStations'[Stn_Latitude])*
COS(RELATED('GIS.LifeboatStations'[Stn_Longitude] - LB_Incident_Post1970[Incident_Longitude]))
*6371)))
Can someone spot where i have gone wrong? I'm getting the error "Function RELATED expects a fully qualified column reference as it's argument".
Solved! Go to Solution.
@rogerdea , seem like a problem with ) , check one in bold
Distance = ACOS(SIN('LB_Incident_Post1970'[Incident_Latitude])*
SIN(RELATED('GIS.LifeboatStations'[Stn_Latitude])+
COS('LB_Incident_Post1970'[Incident_Latitude])*
COS(RELATED('GIS.LifeboatStations'[Stn_Latitude])*
COS(RELATED('GIS.LifeboatStations'[Stn_Longitude]) - LB_Incident_Post1970[Incident_Longitude]))
*6371))
@rogerdea , seem like a problem with ) , check one in bold
Distance = ACOS(SIN('LB_Incident_Post1970'[Incident_Latitude])*
SIN(RELATED('GIS.LifeboatStations'[Stn_Latitude])+
COS('LB_Incident_Post1970'[Incident_Latitude])*
COS(RELATED('GIS.LifeboatStations'[Stn_Latitude])*
COS(RELATED('GIS.LifeboatStations'[Stn_Longitude]) - LB_Incident_Post1970[Incident_Longitude]))
*6371))
Hi @rogerdea ,
Found a related thread, see if any of the suggesstions is applicable in your case.
If not, please share your pbix file removing all the sensitive data, to try and replicate the issue.
Thanks
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |