find overlapping Extended event from date time

Hi Anonymous ,

Try the following DAX:

Last overlapping Date =
VAR start_date = ErrorLogs[Start Date]
VAR end_date = ErrorLogs[DatewithaddedSeconds]
VAR _index = ErrorLogs[Index]
VAR a =
    MAXX (
        FILTER (
            ErrorLogs,
            ( ErrorLogs[DatewithaddedSeconds] >= start_date
                && ErrorLogs[DatewithaddedSeconds] <= end_date )
                && [Index] <> _index
        ),
        [DatewithaddedSeconds]
    )
VAR b =
    LOOKUPVALUE ( ErrorLogs[Index], ErrorLogs[DatewithaddedSeconds], a )
RETURN
    IF ( b > ErrorLogs[Index], a )

Here is the result.