Forum Discussion

Sowmiya's avatar
Sowmiya
Helper III
6 years ago

Distance between two Zip Code/Address

Hi Community,
Guide me in implementing the requirement.

I Have two Excel sheets,
One Sheet lists info about School name and its Address, Zip Code
Another Sheet lists info about Teacher Name and their Address, Zip Code

 

Requirement is to:
Find the School list which are within 20 kilometer of each Teacher based on Zip Code or Address.

Thanks in advance,
Sowmya

 

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    6 years ago

    Sowmiya ,

     

    I'm afraid this can't be achieved. Currently, the map visual in power bi doesn't support calculate distance between two address. You may submit your idea here to help power bi improve.

     

    Regards,

    Jimmy Tao