Forum Discussion

zuber85's avatar
zuber85
Frequent Visitor
2 years ago
Solved

Finding closest Clinic from a given postcode

Hi,

 

I need some help with making a PowerBi Report.

 

We have 6 clinic post codes, and I would like to work a way of being able to tell me which is my closest clinic and the distance to that clinic, with a given post code.  

 

The clinics locations will grow overtime, so would need have the ability to increase them

 

Is this something that is possible?

Need Help

8 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Define "closest".  As the crow flies, or on a road network?  Which distances are we talking about? Can you use approximations based on the general location, or do you need to use the Great Circle calculation?

    • zuber85's avatar
      zuber85
      Frequent Visitor
      2 years ago

      Hi thanks for your reply.

       

      Looking at distance, we can use crow flies and would like to use the Great circle calculation.

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        Sounds good. Please provide sample data that fully covers your issue.