Question in regards to query

[Anonymous]

Hi, i need help as in this below query is for the earliest start time. Now what i want to find out is the earliest stop time with the next user and this user can be anyone apart from the user that has already worked on the case in the first time the earliest start time activity was processed. 

Earliest Start Time (UTC) = CALCULATE(MIN(activityinstances[Start]), FILTER(activityinstances, activityinstances[unique_id]=CaseIDs[unique_id] && activityinstances[Is Start]="TRUE"))

[v-stephen-msft]

Hi @Anonymous ,

As a workaround, you could add the last refreshed date and time to the report, hope it helps.

How to Add the Last Refreshed Date and Time to a Power BI Report | Ask Garth

let

Source = #table(type table[Date Last Refreshed=datetime], {{DateTime.LocalNow()}})

in

Source

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.