Forum Discussion
Design Approach - 4x Week Task lookead Required
Anonymous , Have week rank in date table then use concatenateX
Have these new columns in Date Table, Week Rank is Important in Date/Week Table
Week Rank = RANKX('Date','Date'[Week Start date],,ASC,Dense)
OR
Week Rank = RANKX('Date','Date'[Year Week],,ASC,Dense) //YYYYWW format
These measures can help
This Week = CALCULATE(concatenateX(Table, 'Table'[Task Name], ", "), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))
Next Week = CALCULATE(concatenateX(Table, 'Table'[Task Name], ", "), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])+1))
Next Week +2= CALCULATE(concatenateX(Table, 'Table'[Task Name], ", "), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])+2))
Next Week +3= CALCULATE(concatenateX(Table, 'Table'[Task Name], ", "), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])+3))