Forum Discussion
need help with calculation median for Cycle Time (azure devops)
i have dataset from Azure DevOps (about team work activity), based exist data i alredy create measure for calculate Cycle time (sum duration in certain state) but if see on graph vizulization that da...
Hi Anonymous ,
What's your expected output? Put all cycle time in one column and put median/max/min in one column? You can try the following measure:
Cyclte time (period_) = CONCATENATEX('Table','Table'[Cycle Time],"+") median/max/min = MEDIAN('Table'[Cycle Time])&"/"&MAX('Table'[Cycle Time])&"/"&MIN('Table'[Cycle Time])If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
v-deddai1-msft
Community Support
Community SupportHi Anonymous ,
What's your expected output? Put all cycle time in one column and put median/max/min in one column? You can try the following measure:
Cyclte time (period_) = CONCATENATEX('Table','Table'[Cycle Time],"+")
median/max/min = MEDIAN('Table'[Cycle Time])&"/"&MAX('Table'[Cycle Time])&"/"&MIN('Table'[Cycle Time])
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai