Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
Proud to be a Super User!
Yes! That works - thank you! Is there a way to hide that column from the report?
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
Proud to be a Super User!
Yes! That works - thank you! Is there a way to hide that column from the report?
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
Proud to be a Super User!
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.
@GQ ,
You are welcome!
Good luck!
Nathaniel
Proud to be a Super User!
Disregard - all is working as desired.
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
Proud to be a Super User!