Forum Discussion
EXCEPT function not returning the correct details
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.
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).