Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
5 years ago

Filtering based on two calculated columns using OR

I have two calculated columns with results either showing "yes" or "no" based on due dates.  How can I filter to show results that are Yes for column A   OR       Yes for Column B   Column A       ...
Need Help
mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

In the query editor, add a new custom column with a formula like this and then filter on it.

 

= if [Column A] = "Yes" or [Column B] = "Yes" then "Keep" else "Remove"

 

Pat

 

  • jcastr02's avatar
    jcastr02
    Post Prodigy
    5 years ago

    mahoneypat   Thank you for help.   Since they are two calculated columns, they don't come up under the "available columns" for me to select from.  any guidance would be appreciated.