Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Filter with multiple conditions plus OR

I'm creating a report that needs to list all units in a table that have a scanned in date of either:  today with a time <+ 11:30 am OR yesterday with a time >= 11:30 am.  Currently the date and time...
Filter
IF OR
  • Nathaniel_C's avatar
    Nathaniel_C
    3 years ago

    Hi Anonymous ,

    Include = IF(AND(Max(FTable[Date])=TODAY(),MAX(FTable[Time])<= TIMEVALUE("11:30 AM")) || AND(Max(FTable[Date])=TODAY()-1,MAX(FTable[Time])>= TIMEVALUE("11:30 AM")),1,0)

    Please try this.

    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel

  • Anonymous's avatar
    Anonymous
    3 years ago

    Yes! That works - thank you!  Is there a way to hide that column from the report?

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous ,

Include = IF(AND(Max(FTable[Date])=TODAY(),MAX(FTable[Time])<= TIMEVALUE("11:30 AM")) || AND(Max(FTable[Date])=TODAY()-1,MAX(FTable[Time])>= TIMEVALUE("11:30 AM")),1,0)

Please try this.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Yes! That works - thank you!  Is there a way to hide that column from the report?

  • Nathaniel_C's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Anonymous ,
    You are welcome! 

    Good luck!

    Nathaniel

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Disregard - all is working as desired.  

  • Nathaniel_C's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi Anonymous 
    Which column?

    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      I've evidently done something wrong.  When I apply the filter to the visual, my date column (not the date I'm filtering) disappears, but the unit number column remains.  I don't believe it has the correct, filtered units however.

       

      I'll continue to experiment and get back to you.