Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to compare two tables to filter data

Hi, I have one table with 3 years of monthly sales that includes products numbers and an additional table with about 500 products numbers I want to pull sales totals for.  How do I get it to filter ...
Need Help
Show and Tell
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi Anonymous ，

     

    You can add a filter in your formula ：

     

    'Table'[List Number]  IN VALUES('Table2'[Nums Q4])

     

    Best Regards,

    Dedmon Dai

Anonymous's avatar
Anonymous
Not applicable
6 years ago

The link you provided is no longer valid.  I only want the visual to show the product numbers that are the on Q4 Prod nums list that are included the 2017 file in the List Number field. 2017 would be my main file and Q4 Prod nums my secondary file.  In essence a vlookup to determine the sales for certain product numbers during a partical year. Screenshots are attached.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous Do you have a relationship between your two tables?

 

If not, you can also accomplish this using the IN operator.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Greg!

     

    I don't have a relationship set up between the two tables.  How would I do that?

     

    Thanks for helping the newbie!

     

    _stephanie 

    • v-deddai1-msft's avatar
      v-deddai1-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi Anonymous ，

       

      You can add a filter in your formula ：

       

      'Table'[List Number]  IN VALUES('Table2'[Nums Q4])

       

      Best Regards,

      Dedmon Dai