cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Overlapping 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 NameAppointment Start DatetimeAppointment End DatetimeService CodeStaff Name
DANE, JOE7/28/2020 10:007/28/2020 11:00H0032CLINICAL RBT 3
DANE, JOE7/30/2020 13:007/30/2020 13:30H0004CLINICAL LEAD C
DANE, JOE7/30/2020 13:007/30/2020 14:00H0032CLINICAL RBT 3
DOE, JANE7/28/2020 8:007/28/2020 10:3097153CLINICAL RBT 2
DOE, JANE7/28/2020 10:307/28/2020 12:0097153CLINICAL RBT 2
DOE, JANE7/28/2020 12:007/28/2020 14:0097153CLINICAL RBT 2
DOE, JANE7/28/2020 14:007/28/2020 15:0097153CLINICAL LEAD A
DOE, JANE7/28/2020 14:007/28/2020 17:0097155CLINICAL LEAD B
DOE, JANE7/28/2020 15:007/28/2020 16:0097153CLINICAL RBT 1
DOE, JOHN7/27/2020 8:007/27/2020 11:00H2019CLINICAL RBT 3
DOE, JOHN7/27/2020 9:007/27/2020 10:00H0032CLINICAL LEAD A
DOE, JOHN7/27/2020 9:007/27/2020 11:00H0032CLINICAL LEAD B
DOE, JOHN7/27/2020 11:007/27/2020 13:30H2019CLINICAL RBT 2
DOE, JOHN7/27/2020 13:307/27/2020 15:00H2019CLINICAL RBT 1
DOE, JOHN7/27/2020 15:007/27/2020 16:00H2019CLINICAL RBT 1
DOE, JOHN7/27/2020 16:007/27/2020 17:00H0004CLINICAL LEAD A
DOE, JOHN7/27/2020 16:007/27/2020 17:00H0032CLINICAL LEAD A
DOE, JOHN7/27/2020 16:007/27/2020 17:00H2019CLINICAL RBT 1

 

CodeType
H0032Super
H0004Super HL
97153Direct
97155Super
H2019Super

 

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 2
Highlighted
Super User IV
Super User IV

@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.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted

@Greg_Deckler Thanks I will attempt to do this!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors