Forum Discussion
Consecutive Week End Dates
Hello Team, Trying to implement the solution for the Consecutive Week End date, Below is the detail description of the same, Let's say if i choose any date from my date slicer then it should ...
Anonymous , Create a date tbale with these new columns
new columns
Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)
Week Rank = RANKX(all('Date'),'Date'[Week end date],,ASC,Dense)
OR
Week Rank = RANKX(all('Date'),'Date'[Year Week],,ASC,Dense) //YYYYWW format
measures for next 4 weeks
next 4 weeks = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]>=max('Date'[Week Rank])+1 && 'Date'[Week Rank]<=max('Date'[Week Rank]) +5))
It's only for the next four weeks.. Its not working only for the selected month week end dates.i mean it's going further in next months week end dates..