Forum Discussion
Create a table filtering for multiple values - logical OR
Hello community,
I have a table named "transactions" with a column named "account name". Within the account name column, there are numerous accounts. I would like to build a table to filter for two specific accounts. I can create a table filtering for one account, but cannot figure out how to filter for account "A" or account "B"
Would greatly appreciate any and all assistance.d
Jim
Hi JimB-GA ,
In DAX, you can use "||" as "or". You can refer to this article: Logical operators.
Best Regards,
IceyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Did you try slicer for this task? Because in slicer options you can choose multiple selection and then see filtered values based on two accounts :)
Mantas
Hi JimB-GA ,
In DAX, you can use "||" as "or". You can refer to this article: Logical operators.
Best Regards,
IceyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
My apologies! I have been out of the country. Works perfectly!
Thanks so much!
Jim
