Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Good Morning,
I'm a new user in the Power BI world and would like to try to figure out a way to select the most optimal ship from Distribution center based on the customers zip code and its proximity to the Distribution Center.
For example, I have one Distrubution center in California and one in Maine. I have 100k Orders, based on customer zip code and/or address. I would like to determine which Distribution Center makes the most sense to ship form to get the the quickest time in transit.
Any help would be greatly appreciated!
Using the Haversine formula:
Distance =
VAR CustomerLat = Customers[Latitude]
VAR CustomerLong = Customers[Longitude]
VAR CenterLat = DistributionCenters[Latitude]
VAR CenterLong = DistributionCenters[Longitude]
VAR Radius = 6371 -- Earth's radius in kilometers
VAR LatDiff = RADIANS(CenterLat - CustomerLat)
VAR LongDiff = RADIANS(CenterLong - CustomerLong)
VAR a = SIN(LatDiff / 2) * SIN(LatDiff / 2) + COS(RADIANS(CustomerLat)) * COS(RADIANS(CenterLat)) * SIN(LongDiff / 2) * SIN(LongDiff / 2)
VAR c = 2 * ATAN2(SQRT(a), SQRT(1 - a))
RETURN Radius * c
After calculating the distances, create a measure to determine which distribution center is closest to each customer.
OptimalDistributionCenter =
IF(
[DistanceToCenter1] < [DistanceToCenter2],
"California Distribution Center",
"Maine Distribution Center"
)
💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
78 | |
63 | |
52 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
61 | |
60 |