Forum Discussion

dymetre973's avatar
dymetre973
Frequent Visitor
4 years ago

Comparing 2 data tables

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 ?

 

 

Need Help

3 Replies

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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
        )
    )
)
  • dymetre973's avatar
    dymetre973
    Frequent Visitor
    4 years ago

    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's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      4 years ago

      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.