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.
"Forecast" for week logic is based on sum of points <= 20 order by stackorder asc.
if it more than 20 points tickets(ID) falls into next week. how do i get forecast column? Group < 20 is just calculation for more understanding.
Go to Solution.
Try to create a new column like below:
Column 2 = var total_ =
var week_number = ROUNDUP(DIVIDE(total_,20),-0.1)
return "week "&week_number
View solution in original post
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
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.
@parry2k any help?
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!
Learn how to create your own user groups today!