Direct Query - WorkQueue / WorkQueueItems

Hi! hsiddiq 

Try this CompletedOn = Table1[CompletedOn] + TIME(10, 0, 0)

Hi hsiddiq ,

Thank you for reaching out. I understand you are trying to count the WorkQueueItemID where Statecode = 2 and CompletedOn is within the last 60 minutes, but you are facing challenges with the datetime conversion from UTC to AEST.

Firstly, I would like to ask if the suggestion provided by another user helped resolve your issue.

For counting calculation, you could try:

Processed_last60min =
CALCULATE(
    COUNT('workqueueitem'[workqueueitemid]),
    'workqueueitem'[statecode] = 2,
    'workqueueitem'[completedon] >= (CurrentTimeStampSydney - TIME(1, 0, 0))
)

If the issue persists, could you please provide some sample data and the expected results? This will help us better understand the problem and provide a more accurate solution.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.