Forum Discussion
EXCEPT function not returning the correct details
Anonymous , In that case, second table to be first
EXCEPT(Distinct('ON START STORIES''[Story ID]),Distinct('ON END STORIES'[Story ID]) )
The result is still not coming right. I think the relationship mapping is getting ignored while finding the distinct items based upon id(may be other columns hold different values in different tables for same unique id on different dates).
Is it somehow possible to compare the two tables based upon unique id only while keeping other columns intact in the resultant differential table and select rest of the other columns from the second table? This way, I can find the differential ids and then their related columns from second table that follows the managed relationship(operation is: second-first, where both have multiple columns that change values except the ids).