Forum Discussion

acrmorris's avatar
acrmorris
Frequent Visitor
9 years ago
Solved

filtering duplicate data across 2 tables

Hi,   I have looked for a solution elsewhere on this forum to my specific problem and cannot find anything that helps, but apologies if anybody knows of a posted solution and please point me in the...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    acrmorris

    Hi Usates,

     

    After combining the two tables using Appending Queries, to remove the duplicated rows, please go to Remove Rows -> Remove Duplicates.

     

    If you have any question, please feel free to ask.

     

    Best regards,
    Yuliana Gu

ankitpatira's avatar
ankitpatira
Community Champion
9 years ago

acrmorris There is an easy way to do this. Go to power bi desktop query editor -> Under Home tab far right under Combine -> Append Queries as New -> select table 1 and 2 -> Remove unwnated columns except StoreID. You now have store ids from both the tables. Only thing to make sure is before you do this column name for store ids is same for both the tables.

acrmorris's avatar
acrmorris
Frequent Visitor
9 years ago

ankitpatira, thanks for this. I tried this method, but it seems that some duplicates remain. I am expecting the total population of store IDs to be 1,324  but this method leaves me with 1,660 line items (The total of the 'zero sales for 1 week' table is 500, so it seems to work to some extent) . I have exported the query to Excel and applied a simple 'duplicate value' conditional format which throws out the remaining duplicates correctly. Do you have any idea why this might be?