Forum Discussion
11 Week Look Ahead Dynamic Calculation
- 4 years ago
Hi, Anonymous
You can create this summary table, or use it as a table filter in other measures.
Like this:
Two columns first:
weekday = WEEKDAY([Date],2)weeknum = WEEKNUM([Date],1)Table1 = VAR a = MAXX ( FILTER ( ALL ( 'Table' ), [Date] = TODAY () ), [weeknum] ) RETURN SUMMARIZE ( FILTER ( ALL ( 'Table' ), [weeknum] = MAXX ( FILTER ( ALL ( 'Table' ), [weeknum] = a + 11 ), [weeknum] ) ), [Date], [weekday], [weeknum] )Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey - 4 years ago
HelloAnonymous
Because I don't know what your requirements are used for, so I just created a table.
You need to create table by new table button.
Reference:
SUMMARIZE function (DAX) - DAX | Microsoft Docs
Can you share your formula and error screenshots in the report? If you can describe in detail how your needs are presented in the report visual, I can help you more specifically.
Best Regards,
Community Support Team _ Janey
Thank you! I was able to create the table. Thank you so much and I apologize for my delayed response to this. So would I just use the scheduled start in the newly created table to filter by the t-week? Also, for some reason I'm not able to copy and paste anything into these text boxes. It gives me an error everytime.
Anonymous
You can have a try. I'm not sure which way you created the table in the end, please explain the problem in detail.
Janey