Overlapping Appoints of a Specific Type

[andersona1983]

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. 

[Greg_Deckler]

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

[andersona1983]

@Greg_Deckler Thanks I will attempt to do this!