Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mateusz_ta
Frequent 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. 

 

1 ACCEPTED SOLUTION
johnt75
Super User
Super User

Instead of VALUES use DISTINCT.

View solution in original post

1 REPLY 1
johnt75
Super User
Super User

Instead of VALUES use DISTINCT.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.