Filter with multiple conditions plus OR

[GQ]

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 are separate columns.

I'm new to Power BI and am guessing I need to use DAX but have not hit upon the correct syntax combination.

[Nathaniel_C · Accepted solution]

Hi @GQ ,

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

[Nathaniel_C · Accepted solution]

Hi @GQ ,

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

[GQ · Accepted solution]

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

[Nathaniel_C]

Hi @GQ 
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

[GQ]

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]

@GQ ,
You are welcome! 

Good luck!

Nathaniel

[GQ]

Disregard - all is working as desired.  

[Nathaniel_C]

Hi @GQ ,
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