Comparing 2 data tables

[dymetre973]

I have 2 tables containing airline data with airline code, arrival & departure code and arrival time & departure time 

Im trying to create a table that compares the 2 tables below and shows me if 2 airlines have departure times from the same arrival airport code that are less than 1 hour apart.

Any help ?

[dymetre973]

The data for these 2 tables is populated from the same source. I just edited the interations so that allow them to be operate seperately.  Can a bridge table still solve this if they are both pulling from 1 table ? 

[tamerj1]

@dymetre973 

That means they have different filtets. No need in this case to a bridge table we just need first to carefully understand the filter context of each one in order to replicate it using dax code. 

[tamerj1]

Hi @dymetre973 

you may start with creating a bridge table that contains all the unique Airport Codes and filters both tables. Then you slice by the Airport Code from the bridge table and use the following measure 

Count =
SUMX (
    Table1,
    SUMX (
        Table2,
        IF (
            ABS ( DATEDIFF ( Table1[Departure Time], Table2[Departure Time], MINUTE ) ) < 60,
            1
        )
    )
)