Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
19 | |
15 |