Forum Discussion

Magpie_Rob's avatar
Magpie_Rob
Helper I
5 years ago
Solved

Distance Bins based on long and lat

Hello   So I have 2 tables, on with customers and there Longitude and Latitude and anotherone with Stores with there longitude and latitude - I'm trying to create a table with a list of the stores ...
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    Magpie_Rob is this what you are looking for:

     

     

  • Magpie_Rob's avatar
    Magpie_Rob
    5 years ago

    This was the main bit! it worked really well thank you! 

    Store Distance Bins = 
ADDCOLUMNS (
    CROSSJOIN (
        VALUES ( Store_Location[Postcode] ),
        VALUES ( 'Customers Locations'[id] )
    ),
    "Miles", [Miles],
)

     

parry2k's avatar
parry2k
Super User
5 years ago

Magpie_Rob is this what you are looking for:

 

 

  • Magpie_Rob's avatar
    Magpie_Rob
    Helper I
    5 years ago

    parry2k yeah thats exactly what I'm looking for! are you able to share the pbix or let me know how you achived it? 

    • Magpie_Rob's avatar
      Magpie_Rob
      Helper I
      5 years ago

      Hi parry2k just checking you haven't forgot about me! the soultion to this would be very much appricated! 

       

      Thanks 

  • Magpie_Rob's avatar
    Magpie_Rob
    Helper I
    5 years ago

    This was the main bit! it worked really well thank you! 

    Store Distance Bins = 
ADDCOLUMNS (
    CROSSJOIN (
        VALUES ( Store_Location[Postcode] ),
        VALUES ( 'Customers Locations'[id] )
    ),
    "Miles", [Miles],
)