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

     

V-lianl-msft's avatar
V-lianl-msft
Community 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
    Helper 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.