topic Re: Filter with multiple conditions plus OR in DAX Commands and Tips

Filter with multiple conditions plus OR

Anonymous — Mon, 16 Jan 2023 21:01:37 GMT

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.

Re: Filter with multiple conditions plus OR

Nathaniel_C — Mon, 16 Jan 2023 21:39:08 GMT

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

Re: Filter with multiple conditions plus OR

Nathaniel_C — Mon, 16 Jan 2023 21:44:30 GMT

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

Re: Filter with multiple conditions plus OR

Anonymous — Tue, 17 Jan 2023 14:28:44 GMT

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

Re: Filter with multiple conditions plus OR

Nathaniel_C — Tue, 17 Jan 2023 14:23:51 GMT

Anonymous ,
You are welcome!

Good luck!

Nathaniel

Re: Filter with multiple conditions plus OR

Nathaniel_C — Tue, 17 Jan 2023 15:17:14 GMT

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

Re: Filter with multiple conditions plus OR

Anonymous — Tue, 17 Jan 2023 16:39:46 GMT

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.

Re: Filter with multiple conditions plus OR

Anonymous — Thu, 19 Jan 2023 18:28:04 GMT

Disregard - all is working as desired.