cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JimB-GA Member
Member

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 table with 2 criteria?  I have another account name = 'Money Market"
 
THanks
 
Jim from GA
1 ACCEPTED SOLUTION

Accepted Solutions
EugenioJunior Frequent Visitor
Frequent Visitor

Re: How to create a table with 2 filtered criteria

Hi @JimB-GA 

Try this:

 

FILTER(Transactions,Transactions[Account Name] = "Savings" || Transactions[Account Name] = "Money Market")
4 REPLIES 4
EugenioJunior Frequent Visitor
Frequent Visitor

Re: How to create a table with 2 filtered criteria

Hi @JimB-GA 

Try this:

 

FILTER(Transactions,Transactions[Account Name] = "Savings" || Transactions[Account Name] = "Money Market")
Community Support Team
Community Support Team

Re: How to create a table with 2 filtered criteria

@JimB-GA ,

 

You may also use The IN operator in DAX.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JimB-GA Member
Member

Re: How to create a table with 2 filtered criteria

Thanks!

 

 

Jim-GA

JimB-GA Member
Member

Re: How to create a table with 2 filtered criteria

Thanks.  Just learned about the double pipe!