Forum Discussion
EXCEPT function not returning the correct details
I have two tables which are formed by extracting one similar column(STORY ID) from two different multicolumn tables. The two tables are like below: Now, I want to calculate the difference b...
Anonymous , Try only for Id
EXCEPT(Distinct('ON END STORIES'[Story ID]) , Distinct('ON START STORIES''[Story ID]))
This will not compare other columns
Still no luck. Now if I try just on one column, I am getting all the ids from second table and not the difference between the two. It should calculate the difference between the two and return which are present in second and not the ones in first.