comparing columns
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.