Forum Discussion
mateusz_ta
3 years agoFrequent Visitor
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] ) ) ...
- 3 years ago
Instead of VALUES use DISTINCT.
johnt75
3 years agoSuper User
Instead of VALUES use DISTINCT.