Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |