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.

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

    Hi Anonymous ,
    Original table:

    Select the table, and drop the measure into the filter pane and set the filter to 1:


    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