Distance between two Zip Code/Address

[Sowmiya]

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

[v-yuta-msft]

@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