How to create a table with 2 filtered criteria

[JimB-GA]

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

[v-chuncz-msft]

@JimB-GA ,

You may also use The IN operator in DAX.

[EugenioJunior · Accepted solution]

Hi @JimB-GA 

Try this:

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

[JimB-GA]

Thanks.  Just learned about the double pipe!

[JimB-GA]

Thanks!

Jim-GA