Forum Discussion

3 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support

    Hi, Whibley92 ;

    Based on my understanding, it should be possible, can you create a simple test file, along with the results you want to output and the logic behind it?

    It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

    Solved: How to upload PBI in Community - Microsoft Power BI Community


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Whibley92's avatar
      Whibley92
      Icon for Helper II rankHelper II

      hi v-yalanwu-msft 

       

      this is the data but there are 1300 hotels and 600 stores. 

      Store IDPostocde
      12345CH5 1UA
      23456HU7 3DA
      54311WA3 3SP
      76536OL6 7PF
      64234LE10 1SS
      64243WN7 5RZ
      HotelPostcode
      AB HotelLS16 7YR
      Black  HotelCF1 7JL
      Ham HotelNE11 9XS
      Youngs HotelG77 6EY
      Old HotelPL25 4PR
      Upper HotelDA11 0DQ

       

      I've managed to plot this, but we want to show how many hotels near each store