Forum Discussion
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 cli...
distances are in km.
distances are in km.
Wow, thanks.
Now what if I wanted it so that if I just enter a single postcode it will give me a result? Like how you have a table of the results, I will be having over 160k post codes, so rather than a manual search a postcode is just entered
You can have a slicer. It won't be fast but it will work. Personally I would use the filter pane with Advanced filtering.
Do I need to remind you of the KM to Miles conversion factor? What type of mile?