Forum Discussion
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_T...
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