Traveling salesman problem in PowerBI

Question

HI,&nbsp;I have list of latitude, longitude points and I would like to find shortest way between points. What I was thinking is using Traveling salesman methods to create list of From To points. Do you have any idea how to do this so I can display it in PowerBI service. Maybe R package or something similar? Thanks

v-qiuyu-msft · Answer

Hi Anonymous,
&nbsp;
I think you can refer to&nbsp;ankitpatira's&nbsp;article&nbsp;R script and R visuals in Power BI&nbsp;and this video: DesignMind Power BI Showcase Airline Analysis .
&nbsp;
Best Regards,Qiuyun Yu

anonymous · Answer

Thanks, this looks very promising. I will take better look later today. Thanks again :)

anonymous · Answer

v-qiuyu-msft, you have pointed me into right direction, to use R scripts and I found TSP package for R, but I'm still trying to handle it in wanted manner. I will update this topic with progress made. Thanks&nbsp;v-qiuyu-msft

anonymous · Answer

Hi Anonymous,Did you ever end up finding a solution to your problem? I am currently looking to do the same thing.Thanks!

Forum Discussion

Traveling salesman problem in PowerBI

4 Replies

Related content

Delta Table time travel not readable

Logic problem?

Slider problems

FILTERING PROBLEM

Refresh problem