Forum Discussion
Anonymous
5 years agoNot applicable
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...
v-lionel-msft
5 years agoCommunity Support
Hi Anonymous ,
Are your fields in the same table? If so, you only need to add the Filter() function to the measure to filter out the closed items.
If this problem still can not be solved, please show me the sample data.
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.