Comparing 2 data tables

Question

I have 2 tables containing airline data with airline code, arrival &amp; departure code and arrival time &amp; departure time&nbsp;&nbsp;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.&nbsp;Any help ?&nbsp;&nbsp;

tamerj1 · Answer

Hi&nbsp;dymetre973&nbsp;
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&nbsp;
Count =
SUMX (
    Table1,
    SUMX (
        Table2,
        IF (
            ABS ( DATEDIFF ( Table1[Departure Time], Table2[Departure Time], MINUTE ) ) &lt; 60,
            1
        )
    )
)

dymetre973 · Answer

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.&nbsp; Can a bridge table still solve this if they are both pulling from 1 table ?&nbsp;

tamerj1 · Answer

dymetre973&nbsp;
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.&nbsp;

Forum Discussion

Related content

Table Sort , sort order , comparer

Compare 2 Tables

Compare two tables' data in power BI

Comparing Two Sales Tables

Compare 2 tables