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

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