comparing columns

kenayabreu123 — Thu, 18 Aug 2022 10:23:49 GMT

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.

Re: comparing columns

technolog — Thu, 18 Aug 2022 11:31:03 GMT

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

topic Re: comparing columns in DAX Commands and Tips

comparing columns

Re: comparing columns