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.
Hi All,
I would like to calculate the distance between the sales rep visiting customers, how many km sales rep traveled/day based on the outlet we have assigned. Sales rep will leave from the location where we assign and visit the customers.
From our side we would like to understand the distance of one sales rep visits the outlets, as what i did on google map below. the map below shows the distance 3.8km, starting from the location I have circled to other locations. Is PBI can perform such formula?
in the report , we will show the total KM of Sales rep visiting their customers based on date filter.
Solved! Go to Solution.
Thanks for your reply.
>>Not sure whether PBI can calculate all the distance between 1 to another ?
It is possible to achieve it if detailed data of all locations are provided as in this article below. The output can then be displayed in a table visual. If you want to display the output in a Map, you need to consider using tooltip. for example, when your mouse hovers over a location, the tooltip will show the distances to all related locations
Distance Calculation On Map | Power BI Geospatial Analysis - Enterprise DNA
Hope this helps!
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Thanks for reaching out to us.
I doubt if it is possible to calculate distance in a map. For distance calculation, you need to create an auxiliary table with all the address information first. Here are 2 posts for your reference,
Calculate the Distance between Two Locations - Microsoft Power BI Community
Solved: Distance Calculation in Power BI - Microsoft Power BI Community
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-xiaotang , sales rep will continually visit one outlet to another outlet within around the area . The assign location from warehouse and outlets around the area will be calculated based on the distance from one to another . I can done this through google map as shown . Not sure whether PBI can calculate all the distance between 1 to another ? It can be an averages .
Thanks for your reply.
>>Not sure whether PBI can calculate all the distance between 1 to another ?
It is possible to achieve it if detailed data of all locations are provided as in this article below. The output can then be displayed in a table visual. If you want to display the output in a Map, you need to consider using tooltip. for example, when your mouse hovers over a location, the tooltip will show the distances to all related locations
Distance Calculation On Map | Power BI Geospatial Analysis - Enterprise DNA
Hope this helps!
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
100 | |
99 | |
76 | |
66 | |
61 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |