Forum Discussion

Dihros's avatar
Dihros
Frequent Visitor
6 years ago

Equitable distribution by shorter distance - Geolocation

Appreciable all I require your support for the following, I need to assign clients to the closest manager by location, but these assignments should be distributed evenly, if the closest manager is a...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

to deepen the performance aspects (certainly the use of list.accumulate is not highly recommended), it is necessary to know:
the number of locations?
for each location how many managers? 10 to 15 managers, for example
for each location how many customers? 100 to 250 customers, for example

 

PS

What data did you test the code on and how long did it take?

what is a time you reasonably expect?

Dihros's avatar
Dihros
Frequent Visitor
5 years ago

Anonymous 

 

Searching on the net, i found this article,

https://www.thebiccountant.com/2018/08/20/performance-tip-for-list-generate-1-buffer-your-tables-in-power-bi-and-power-query/ 

 

I made the change in the code and it takes less time than before.

 

 

The data set I used for the test is about 300 records, the data is in the code in my previous answer

In my first test it took me more than 5 minutes for only 200 records...

Now I can process 1500 in 6 minutes.

 

I am still looking for improvements because in my final data set there are 33,000 records (every month it's increase) divided in 20 places each one has between 1 and 4 managers having each one on average 1,200 customers; I also have to do other transformations to get the final result, so I need the fastest code , plus I'm not a very patient person  😄