Forum Discussion

aashton's avatar
aashton
Helper V
3 years ago
Solved

Find Overlapping Surgeries

Hello, I have a table with ID, Date, Facility, OR#, Start Time and End Time.  I need to find surgeries that are overlapping in the same facility, same OR, as this is a mistake as two surgeries canno...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    1. Decide your data granulatity level .  Is it half hour slots, 15 minute slots, or minute level slots? What should happen when a surgery goes past midnight?  Better use DateTime values.

    2. For each surgery generate a list of slots based on 1.  (in Power Query)

    3. Load the data into Power BI. List all slots with their rowcount.  Any rowcount above 1 means there is one or more conflicts for that slot.

     

    Here is an example for half hourly slots.

     

     

     

    See attached.

lbendlin's avatar
lbendlin
Super User
3 years ago

1. Decide your data granulatity level .  Is it half hour slots, 15 minute slots, or minute level slots? What should happen when a surgery goes past midnight?  Better use DateTime values.

2. For each surgery generate a list of slots based on 1.  (in Power Query)

3. Load the data into Power BI. List all slots with their rowcount.  Any rowcount above 1 means there is one or more conflicts for that slot.

 

Here is an example for half hourly slots.

 

 

 

See attached.