Find closest customer/ house/ shared bike... to your salespeople/🌋/location ;) in Power BI

[@CurbalEN]

The file is now available for download at curbal.com (get number 71)

[@IslamTWL]

Is it deleted? Unable to find this file

[@HachiAdachi]

🤯 MIND. BLOWN. Sooo many use cases, yet so (relatively) simple!! I feel like my Power BI world just expanded to a whole new horizon, especially because I usually don't get to play with geographical data much. I'm going think about this all day today. Thanks, Ruth!

[@CurbalEN]

Yey!! So cool you see the potential this has :)

[@javiervd7965]

Thx , i need this for my work! you are a life saver!🙂

[@CurbalEN]

At your service :)

[@wayneedmondson1065]

Great video! Thanks Ruth!!

[@roywilson9580]

Great video and a nice solution with the measures. I would certainly be interested in a video showing how to dynamically update the report parameters with power apps.

[@CurbalEN]

Excellent , will do

[@benhalicki9749]

Great trick! Thanks Ruth! :)

[@rosswaterston]

Great video! As you say there are so many applications for this.

[@CurbalEN]

Yes :))

[@brendonbird8988]

WOW WOW WOW, this is so amazing and powerful at the same time! Thank you so much for this video, definitely something I can use

[@CurbalEN]

💃💃 So cool you see the potential :))))

[@QuantumDot2]

Very clever and cool-thanks for showing us how you did it!

[@CurbalEN]

My pleasure;)

[@menthu07]

This is wonderful. Thank you

[@alexkim7270]

This is wonderful. WOW!

[@algenius._]

Señora, no la conozco pero la amo

[@Vintagecrusher]

Nice video. How do I plot a line that shows collection for a truck & its various delivery locations in a power BI map. I am struggling with this.

[@jithiljohn2961]

Great video, can you please make a video on taking current location instead of static locations. Please

[@HaripalSinghThakur]

can you show how did you append your location to Station location data

[@adolfy1972]

hi There, can u make a tutorial for a disaster related for example if earthquake happened in particular area, the purpose is to locate what is the impact in certain radius, impacted place could be ( houses, hospital, etc, with longlat info ) and also the distance from the earthquake ground zero, tks

[@keithkessenger9101]

This is incredibly helpful. I was able to get the closestDistance to work, but if I want to have a measure that indicated which station is closest for each row of "My Location", how do I do that? I have tried to do a calculate, perform the Haversine equation again, but I must be making a mistake. Appreciate any help.

[@marcoantoniobajanabarahona3300]

Congratulations Excellent Video, it is possible to download the file I can't find where to download it. Thanks

[@Milhouse77BS]

I’ll use this today!

[@CurbalEN]

👏👏👏

[@luiscarlosvillasenor2046]

Is this in Kilometers or Miles? How would you diferentiate between both? Thank you!

[@ahmadnadeem870]

Can we use other then circles? Like in Google map pin points

[@notoriousft]

Thanks for the video.

[@CurbalEN]

My pleasure :)

[@FuzzyGuatermelon]

I input the minimum distance calculator onto my data and I dont understand why my distances are being drastically inflated. Ive cross referenced my measures over and over and theyre exactly as they should be with the respective variables.

[@K1NG0FK0LA]

In my report I'm using a list of repair facilities in the slicer and trying to find the closest dealerships to the selected repair facility. In a table the Color station measure shows correctly, but the points on the map are not showing blue any suggestions? Great video btw!!

[@QBNblue]

Hi thank you so much for this video. Do you think it would be possible to hide the myposition2 when you pick my position1 and vice versa. I have about 7 "my positions" and only want to see the one I select in the slicer...thank you:)

[@TheTMUK]

I'm definitely interested in seeing how to use PowerApps to enter a dynamic location parameter which can be updated by the report user

[@CurbalEN]

Will investigate more and keep you updated

[@jatinhingorani3704]

@@CurbalEN any update when you will publish dynamic location video

[@CurbalEN]

Here: curbal.com/curbal-learning-portal/push-the-button-to-find-your-closest-customer-bike-share-in-power-bi?seq_no=2

[@jatinhingorani3704]

@@CurbalEN you are awesome :)

[@chanleaknahang5816]

You’re awesome :)

[@CurbalEN]

You too!

[@zaafirc369]

I was wondering whether it is possible to indicate the barycentre of some latitudes and longitudes on a map on power bi. Barycentre point is the average latitude and longitude of points selected. For example, if deliveries are made on point A,B,C. The barycentre would be the point in the middle of these points. But if a new delivery is made on a point D, then the barycentre would adjust. I don't think it is possible to add a measure in the map visual. Is there a way to do this? Another idea was to adjust the barycentre point with regards to the weight of the deliveries made to each point. The heavy the weight to a point, the closer it would be to it.

[@CurbalEN]

I am sure it is possible , you just need to figure out the calculation and then daxify it ;)

[@GrandeSalva]

Tnks for this video. Can you explane how convert miles in km? Tnks

[@Balraj-s5i]

could you please share me this file please.

[@fajnefajne4339]

Hi Ruth, Great video. Thank you. I just wonder how you have applied the conditional colors there.

[@CurbalEN]

The file is now available for download so you will see everything. Get file 71

[@383man]

@@CurbalEN Hey, i can't seem to find file 71, i see them all the way up to file 70, then the rest aren't numbered...

[@CurbalEN]

Just added it again, not sure what happened!

[@383man]

@@CurbalEN you're awesome, thanks for the quick response :)

[@akshayrajan6241]

@@CurbalEN Hi Ruth, can't seem to find the file 71. Please upload it.

[@allaboutpixhawkandrpi3691]

I keep getting an error mgs saying " An argument of function 'SQRT' has the wrong data type or the result is too small or too large. Can anyone please help. 🙏

[@tonyjenks24]

Would it theoretically possible for the user to select a mylocation, and have another user location come up as the closest if they user locations are in the same table? It would have to be weird source data obv!

[@CurbalEN]

Definitely, same procedure you are only missing the sending the coordinates live :)

[@sukoi2113]

You are so cool

[@aleksandarboshevski]

super excellent. btw what happened with the audio ?

[@CurbalEN]

What happened, is it bad?

[@johnfrank7879]

My audio was fine the entire video

[@CurbalEN]

My too 😥

[@johnfrank7879]

@@CurbalEN guessing it's just Aleksandar. Guess you'll have to use the a Google API to export KZbin comments and generate flags and notifications just to be sure 😂

[@CurbalEN]

Big brother kind of thing… I like it 😂😂

[@kahhengyeong7947]

Interesting... but any way I can convert city addresses into latitudes and longtitudes? Because my database only contains normal city addresses and sometimes they can be inaccurate

[@CurbalEN]

Sure, here : m.kzbin.info/www/bejne/bmi4pJSFjqlgkK8

[@kahhengyeong7947]

@@CurbalEN Thanks!!! It's a life saver because my management lately wants heat maps of sales. By the way, I also could try to make the locations more accurate by combining [ city address, postal code, country ] columns. Although it is not 100% but it is somehow more accurate than just plugging in a street address in the location section.

[@CurbalEN]

Go for it!!

[@shinuignatious308]

Can i get the pbix for this demo ?

[@CurbalEN]

Dang, sure, will try to add it this evening

[@ΠαναγιώτηςΣκούρτης-λ6ρ]

Hi! This is very cool video! I have a question! The calculated distance is by foot, by car? Because when i go to cross check with google maps or bing maps there some difference's in distances in both file' s mine and yours

[@CurbalEN]

This is how I calculated the distance: en.m.wikipedia.org/wiki/Haversine_formula

[@jithiljohn2961]

Can you please add pbix file also?

[@CurbalEN]

Yes definitely

[@jithiljohn2961]

@@CurbalEN It's not uploaded, right?

[@CurbalEN]

Not yet. Will do it as soon as I can!

[@vishwanathbiradar1091]

Hello Team, Thanks for this video. I am reflecting this model to one of my task. However, I didn't find the 'colour my location' referenced in visuals the file you uploaded. Can you explain how it is map is conditionally formatted?

[@vishwanathbiradar1091]

I got it now...thanks 👍

[@CurbalEN]

Sorry for the delay!

[@SuperSanrai]

Can you please reply how it was done, and which map is used to plot points?

[@CurbalEN]

I show everything in the video, watch without skipping

[@PLBL]

Hey! - sorry this isn’t entirely to do with this video but do you know is there a way to embed PowerBI workspace apps into s?

[@CurbalEN]

I don’t know 🤷‍♀️

[@PLBL]

@@CurbalEN That would be insanely cool if we could. Like it would make source control and updates so easy. As well as access control. I'll try look into it some more, but would be really cool if you could make a video on embed :) - love your content!

[@CurbalEN]

Embed is cool but a bit outside my scope. I don’t have enough time to dig into that too :(

[@MonsieurSchue]

How do you get the coordinates to begin with then? Most business may have address for their "stores" but it's not easy to find lat/long info. These days even google map is using their own geo spatial and may not provide lat/long anymore. If one has just 10 location maybe it is still possible to somehow find it one by one, but what if you have 100 or even 1000 shops with just "regular addresses"?

[@CurbalEN]

To get lat/long from addresses follow this tutorial : m.kzbin.info/www/bejne/bmi4pJSFjqlgkK8

[@MonsieurSchue]

@@CurbalEN ahh. Thank you so much. ❤ Let me look at it and try today. Does it still work with these days even when google generates its own coordinates like this M2G8+VP New York, USA?

[@CurbalEN]

Yes, the api will give you lat and long :)

[@feadrian]

This approach where you insert your locations in a fixed table rendered in power query is not very flexible. There's a more dynamic approach where this table cam be done via DAx where you can dynamically select "customer location" and modify all distances measuring against the selected location

[@CurbalEN]

The idea is to get the location from another source into power bi, not hardcode it, but yes, you can also select customer location with DAX.

[@sureshrao174]

This was a interview question which was asked to me during an interview process. Anyone who would like to give it a try. Assignment Details: You are required to create a map view in PowerBI that will show the warehouse locations and would cover all the pin codes within a 180km radius of the warehouse. The attached sheet contains the dataset needed for this assignment. How do I solve this I am still biting my teeth?

[@CurbalEN]

You can use this technique for that, let me do a video for this. I absolutely love this topic :)

[@sledziu32]

booksy had this as interview question XD

[@CurbalEN]

Wild!

[@gulhermepereira249]

Wait, the Earth is not flat?

[@CurbalEN]

Well, it depends on who you ask ;)

[@galaxyangelzz]

how to draw a circle :D

[@CurbalEN]

😂 good question!

[@daveb4137]

Spooky. I was literally asked to solve this exact problem 12 hours ago. The matrix.....

[@AnT508]

I was asked to do this 2 weeks ago as well...

[@CurbalEN]

😂 I seriously considering starting a fortune telling business!