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] ) )
The calculated column contains one blank row I want to get rid of.
None of the input columns contains blank rows and both of them have the same data type - text hence I do not understand why the blank row is there. Also, since this is a calculated table I cannot remove the blank row with the power query because the table doesn't appear in the Power Query Editor view.
Instead of VALUES use DISTINCT.
1 Reply
- johnt75Super User
Instead of VALUES use DISTINCT.