Forum Discussion
Helper IOverlapping Appoints of a Specific Type
Hello,
I am trying to find overlapping appointments of a certain type, on a date, and producing a report of all those appointments that match this.
My data comes in the following format:
| Client Name | Appointment Start Datetime | Appointment End Datetime | Service Code | Staff Name |
| DANE, JOE | 7/28/2020 10:00 | 7/28/2020 11:00 | H0032 | CLINICAL RBT 3 |
| DANE, JOE | 7/30/2020 13:00 | 7/30/2020 13:30 | H0004 | CLINICAL LEAD C |
| DANE, JOE | 7/30/2020 13:00 | 7/30/2020 14:00 | H0032 | CLINICAL RBT 3 |
| DOE, JANE | 7/28/2020 8:00 | 7/28/2020 10:30 | 97153 | CLINICAL RBT 2 |
| DOE, JANE | 7/28/2020 10:30 | 7/28/2020 12:00 | 97153 | CLINICAL RBT 2 |
| DOE, JANE | 7/28/2020 12:00 | 7/28/2020 14:00 | 97153 | CLINICAL RBT 2 |
| DOE, JANE | 7/28/2020 14:00 | 7/28/2020 15:00 | 97153 | CLINICAL LEAD A |
| DOE, JANE | 7/28/2020 14:00 | 7/28/2020 17:00 | 97155 | CLINICAL LEAD B |
| DOE, JANE | 7/28/2020 15:00 | 7/28/2020 16:00 | 97153 | CLINICAL RBT 1 |
| DOE, JOHN | 7/27/2020 8:00 | 7/27/2020 11:00 | H2019 | CLINICAL RBT 3 |
| DOE, JOHN | 7/27/2020 9:00 | 7/27/2020 10:00 | H0032 | CLINICAL LEAD A |
| DOE, JOHN | 7/27/2020 9:00 | 7/27/2020 11:00 | H0032 | CLINICAL LEAD B |
| DOE, JOHN | 7/27/2020 11:00 | 7/27/2020 13:30 | H2019 | CLINICAL RBT 2 |
| DOE, JOHN | 7/27/2020 13:30 | 7/27/2020 15:00 | H2019 | CLINICAL RBT 1 |
| DOE, JOHN | 7/27/2020 15:00 | 7/27/2020 16:00 | H2019 | CLINICAL RBT 1 |
| DOE, JOHN | 7/27/2020 16:00 | 7/27/2020 17:00 | H0004 | CLINICAL LEAD A |
| DOE, JOHN | 7/27/2020 16:00 | 7/27/2020 17:00 | H0032 | CLINICAL LEAD A |
| DOE, JOHN | 7/27/2020 16:00 | 7/27/2020 17:00 | H2019 | CLINICAL RBT 1 |
| Code | Type |
| H0032 | Super |
| H0004 | Super HL |
| 97153 | Direct |
| 97155 | Super |
| H2019 | Super |
If the code type matches, and the appointment is overlapping on a date, I need a flag to occur, and the item would be displayed in a report. Any assistance would be help, or to point me in a direction to start.
2 Replies
- Greg_Deckler
Community Champion
andersona1983 - You could potentially use a variation of Open Tickets, which is designed to work with date/time intervals.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364
In theory, you could count the number of items in each interval and display this count on a column chart. Clicking on any column could filter a table to show you the items that overlap.
andersona1983Greg_Deckler Thanks I will attempt to do this!
