Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Heya All,
I have stucked with following:
Looking for solution to be able to see records between 2 different dates and times which always would follow up on current date.
For example
between YESTERDAY 15:00 - TODAY 14:59
FILTER ( 'Calendar'[DateTime], 'Calendar'[DateTime] > TODAY()-1+TIME(15,0,0) && 'Calendar'[DateTime] <= TODAY()+TIME(14,59,0) )
Could Anyone please help with above?
Many Thanks
Solved! Go to Solution.
Heya @amitchandak
Thank You for pointing to right direction
Figured out the solution:
Measure =
CALCULATE (
COUNT(HEADER[Order]),
HEADER[Custom] >= TODAY()-1+TIME(15,0,0)
&& HEADER[Custom] <= TODAY()+TIME(14,59,0)
)
Created "Custom" column which is my creationdate+creationtime column and filter just works perfectly fine
Many Thanks
Hi @Anonymous ,
If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.
Looking forward to your feedback.
Best Regards,
Henry
Heya @amitchandak
Thank You for pointing to right direction
Figured out the solution:
Measure =
CALCULATE (
COUNT(HEADER[Order]),
HEADER[Custom] >= TODAY()-1+TIME(15,0,0)
&& HEADER[Custom] <= TODAY()+TIME(14,59,0)
)
Created "Custom" column which is my creationdate+creationtime column and filter just works perfectly fine
Many Thanks
@Anonymous , I doubt calendar table will have timestamp, unless you created one for every minute or second
You need a measure like this on datetime column of your table
CALCULATE( sum(Table[Values]) ,
FILTER (
'Table'[DateTime],
'Table'[DateTime] > TODAY()-1+TIME(15,0,0)
&& 'Table'[DateTime] <= TODAY()+TIME(14,59,0)
) )
Heya @amitchandak
Did not work out.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
84 | |
65 | |
62 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |