Forum Discussion

kenayabreu123's avatar
kenayabreu123
New Member
4 years ago

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.

 

Calculatetable
DAX
notcontains

1 Reply

  • technolog's avatar
    technolog
    Super User
    4 years ago

    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