Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How caclculate TouchTime for Azure DevOps

Hello   i want to calc Touch Time (sum working time by closed items per period in certain State). In my data set i have: Work Item Id - item State Time in Days - time in certain State State - St...
Need Help
v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi Anonymous ,

 

Like this? If it's incorrect, please show me the sample data and expected output table like me.

Measure = 
CALCULATE(
    SUM(Sheet2[Working time]),
    FILTER(
        Sheet2,
        [State] = "Closed" && [Weeknum] = MAX([Weeknum])
    )
)

 

Best regards,
Lionel Chen

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

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    isn't correct, i said closed items located in another table, need condtion for comapare source table (Id) = table with closed (Id)