Forum Discussion
Measurement between Selected Dates
| Complaint_ID | Creation_Date | Resolved_Date | Zip |
| 123456789 | 06/01/2021 | 06/03/2021 | 83686 |
| 234567891 | 06/02/2021 | 06/14/2021 | 83686 |
| 345678912 | 06/04/2021 | 06/13/2021 | 83686 |
| 567891234 | 06/05/2021 | 06/10/2021 | 83686 |
| 678912345 | 06/06/2021 | 06/07/2021 | 83686 |
| 789123456 | 06/07/2021 | 06/22/2021 | 83686 |
| 891234567 | 06/08/2021 | 06/15/2021 | 83686 |
| Survey_ID | Zip | Date |
| 5555313 | 83686 | 06/07/2021 |
| 5555314 | 83686 | 06/12/2021 |
Apologies for the late reply, I was not at work and it's tied to my work email so I didn't see the response till today.
I gave some tester data to help get what I'm tyring to do. So if you create a map with this information in power bi on different tables (Can't combine tables because it would duplicate some information) then you create a relationship between the zipcodes that way you can put surveys as a tool tip and complaints (count) as the size, the zipcode that I have there (I used mine to make it easy) will always show that there are 7 tickets open as I am using the date slicer for the surveys to filter the map. The map location is based off of the Zip of the surveys that way it doesn't show any tickets that are elsewhere in the US
I have tried to create another slicer with the date for tickets to just mark it as "Tickets opened between" that way I can at least filter the map to manually show that information. It appears to help update some of the tables that I show on the right side, but on the map itself, it still shows that zipcode has 7 tickets open (in my example here) no matter what dates I have selected so it's not filtering out that date for the tickets, just the surveys. Due to the relationship between the tables, I'm not able to create a calendar table and link both dates to that and this is where I'm getting stuck even with my multiple attempts to try and correct this.
Apologies if this doesn't make a whole lot of sense, day is pretty jam packed and just typing this as I get time 🙂 Thank you for your help!
Hi,
Based on the 2 tables that you have shared, please show the expected result very clearly in a Table format.