comparing columns

[kenayabreu123]

hello, I'm trying to create a calculated table with data from one that doesn't have the other. I am doing
Calculatetable ( FILTER (F_TABLE_1 , NOT CONTAINS (F_TABLE_2 , F_TABLE_2 [costumer_2 ] , F_TABLE_1 [costumer_1] ,  F_TABLE_2 [cod_2 ] , F_TABLE_1 [cod_1] )

this works, but first I want it to validate if the id of one is greater than the other I tried to do that
switch (TRUE () , FILTER ( F_TABLE_2 , F_TABLE_2 [ID_costumer_2 ]) > FILTER ( F_TABLE_1 , F_TABLE_1 [ID_costumer_1]) , Calculatetable ( FILTER (F_TABLE_1 , NOT CONTAINS (F_TABLE_2 , F_TABLE_2 [costumer_2 ] , F_TABLE_1 [costumer_1] ,  F_TABLE_2 [cod_2 ] , F_TABLE_1 [cod_1] )

but that doesn't work, I want it to first validate if the customer id of f_table_2 is greater than the id_customer of f_table_1 and then do the other validations

att: 

the customer id is the joining of the date in numeric format and a few more digits. With each passing day that number increases.

[technolog]

Hi

You can use EXCEPT.

Example:

VAR SunMon =

    CALCULATETABLE (

        VALUES ( 'Date'[Day of Week] ),

        'Date'[Day of Week Number] IN { 1, 2 }

    )

VAR MonTue =

    CALCULATETABLE (

        VALUES ( 'Date'[Day of Week] ),

        'Date'[Day of Week Number] IN { 2, 3 }

    )

VAR ExceptResult = EXCEPT( SunMon, MonTue )

RETURN

    ExceptResult