Forum Discussion

bideveloper555's avatar
bideveloper555
Helper IV
4 years ago
Solved

sub groups by condition (Azure Devops) Forecasting

hi Most have seen Azure Devops data set.(for allocating sprints).   i have scenario: i should able to forecast week for each item based on stackorder ascending. below is sample data. ID Stat...
Need Help
Show and Tell
Tips and Tricks
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Try to create a new column like below:

    Column 2 = var total_ =
SUMX(FILTER('Table','Table'[stackOrder]<=EARLIER('Table'[stackOrder])),'Table'[Points])
var week_number = ROUNDUP(DIVIDE(total_,20),-0.1)
return "week "&week_number