Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Question in regards to query

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"))
Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.