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...
Need Help
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
        )
    )
)