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?

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

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.