Forum Discussion

mateusz_ta's avatar
mateusz_ta
Frequent Visitor
3 years ago
Solved

EXCEPT statement generates a blank row

Hi,   I have a calculated column that has been generated from two other columns using an EXCEPT statement:   New_column = EXCEPT ( VALUES ( 'table1'[column1] ), VALUES ( 'table2'[column2] ) )  ...
  • johnt75's avatar
    3 years ago

    Instead of VALUES use DISTINCT.