Forum Discussion

bideveloper555's avatar
bideveloper555
Icon for Helper IV rankHelper 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

     

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
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

 

bideveloper555's avatar
bideveloper555
Icon for Helper IV rankHelper IV
4 years ago

Thank you this is working perfectly.

but bit of help with dyanmic week number.

currently we are in week 20(current week) lets says. week 20 defined by start date and end date

 
TODAY () >= Table[StartDate]
&& TODAY () <= Table[EndDate]
 

so i need to add above column which you created 20+1 as week 21.

This will chnage next week as week 21, than 21+1 as week 22.