Forum Discussion

JimB-GA's avatar
JimB-GA
Icon for Helper III rankHelper III
7 years ago
Solved

How to create a table with 2 filtered criteria

Good day all,   I have a filtered table which is pulling from a table named 'transactions'.   Savings = filter(transactions,transactions[Account Name]="Savings")   Is it possible to create the...
Need Help
Tutorial Requests
  • EugenioJunior's avatar
    EugenioJunior
    7 years ago

    Hi JimB-GA 

    Try this:

     

    FILTER(Transactions,Transactions[Account Name] = "Savings" || Transactions[Account Name] = "Money Market")
EugenioJunior's avatar
EugenioJunior
Frequent Visitor
7 years ago

Hi JimB-GA 

Try this:

 

FILTER(Transactions,Transactions[Account Name] = "Savings" || Transactions[Account Name] = "Money Market")
  • JimB-GA's avatar
    JimB-GA
    Icon for Helper III rankHelper III
    7 years ago

    Thanks!

     

     

    Jim-GA

  • JimB-GA's avatar
    JimB-GA
    Icon for Helper III rankHelper III
    7 years ago

    Thanks.  Just learned about the double pipe!