Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 between these two and find the ones in second table that are not present in first table.

I am trying using EXCEPT('ON END STORIES', 'ON START STORIES') but this is giving me no result and just showing as blank. Is there anything I am missing here?

 

Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , Try only for Id

     

    EXCEPT(Distinct('ON END STORIES'[Story ID]) , Distinct('ON START STORIES''[Story ID]))

     

    This will not compare other columns

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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.

      • amitchandak's avatar
        amitchandak
        Super User
        3 years ago

        Anonymous , In that case, second table to be first

        EXCEPT(Distinct('ON START STORIES''[Story ID]),Distinct('ON END STORIES'[Story ID]) )

  • serpiva64's avatar
    serpiva64
    Solution Sage
    3 years ago

    Hi,

    i think that you are in the right way

    I made some tests and with your data you should get blank if you swap your tables.

    on other cases you should get errors (column type ecc.)

    If this post is useful to help you to solve your issue consider giving the post a thumbs up 

     and accepting it as a solution !