identify overlapping entries

SebastianAlmer 
I'm not too sure if this will work flawlessly but...

1) Create a new columns in Power Query to return the Date StartTime and Date EndTimes per row.

2) Add a new calculated column to rank the rows by employee, date and task in ascending order based on the StartTime value:

 3) Create a measure to check if a start time overlaps an end time:

Indentify overlapping =
VAR EndDateTime =
    CALCULATE (
        MAX ( 'Table'[End DateTime] ),
        FILTER (
            ALLEXCEPT ( 'Table', 'Table'[date], 'Table'[employee], 'Table'[Task] ),
            'Table'[Order] = 1
        )
    )
VAR StartDateTime =
    CALCULATE (
        MAX ( 'Table'[Start DateTime] ),
        FILTER (
            ALLEXCEPT ( 'Table', 'Table'[date], 'Table'[employee], 'Table'[Task] ),
            'Table'[Order] = 2
        )
    )
RETURN
    IF ( StartDateTime < EndDateTime, 1 )

 And you get this:

Hi SebastianAlmer 
Add a index column to your table and then Create two calculated column like this:

Time Flag = 

var previousendhour=CALCULATE(MAX('Table'[end_hour]),FILTER(ALLEXCEPT('Table','Table'[date]),'Table'[Index]=EARLIER('Table'[Index])-1))

var previousendminute=CALCULATE(MAX('Table'[end_minute]),FILTER(ALLEXCEPT('Table','Table'[date]),'Table'[Index]=EARLIER('Table'[Index])-1))

var previousendtime= (previousendhour*100)+previousendminute

var starttime=('Table'[start_hour]*100)+'Table'[start_minute]

var timeflag=IF(starttime<previousendtime,1,0)

return timeflag

Next Time Flag = CALCULATE(MAX('Table'[Time Flag]),FILTER(ALLEXCEPT('Table','Table'[date]),'Table'[Index]=EARLIER('Table'[Index])+1))

 

and then create a measure like this

Time Filter = IF(SUM('Table'[Time Flag])=1 || sum('Table'[Next Time Flag])=1,1,0)

 

Apply the above measure as a visual level filter to get the desired result:

 

 

In case you need the file here is the link:

https://we.tl/t-XrRjxXyFIH

 

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀

 

 

PaulDBrown jaideepnema 
Really appreciate your solutions there. I might have missed the information that im working in DirectQuery mode. oops...

Do you see any easy solution with direct query? I can't create this calculated column with the "CALCULATE" function and with a measure I'm not able to user "EARLIER". Any idea? if not, then I might need to switch to imported...

thanks in advance

I've switched to import for testing:
jaideepnema 

I have an index that I can use. But it's not ordered by anything. Your index needs to be ordered I assume? Like in the solution of PaulDBrown 

PaulDBrown I've tested your solution. It seems, that it only works, if there are two entries per day, right? How could I do this not knowing how many entries per day?

really appreciate your help🙏

Hi  SebastianAlmer  ,

Hello,

I used your code with some modifications based on my specifications and keep coming up with the same error, even though I am in import mode.

My data table is structured like this. I created the StartTime and EndTime as a column rather than a measure..

Here is my modified code. 

2) 

##

Sum StartTime = SUM(Timecard_Dimensions[StartTime])

##