Displaying Dates after a Selected Start Date for a specific Period

[nesselman]

I would like to show 13 Weeks in a Table, using a "Start From" Week Slicer

I know I can use the Slicer as a BETWEEN, however, I really want the user to just pick a starting week and have the table show that week plus the next 12 weeks.

My Calendar includes:

• Date 
• Week-Start Date

I believe I need to create a second Calendar table for have the Slicer Start from and then a column in original Calendar to show "Display" or "Don't Display" then use that as a filter. 

Each time I do some sort of Column like that it comes back either blank, or all Display or all Dont Display.

I've looked a many, many responses, but most are for all data from a date or using relative date filters.

Any help or links for me to research, I'd appreciate.

[amitchandak · Accepted solution]

@nesselman , if you want to select 1 week and want to show more than one week. then the slicer need to be on independent

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = _max -108
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

or Use week Rank

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Week Rank])
var _min = _max -13
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Week Rank] >=_min && 'Date'[Week Rank] <=_max))

where Week Rank is a column

Week Rank = RANKX(all('Date'),'Date'[Week Start date],,ASC,Dense)
OR
Week Rank RANKX(all('Date'),'Date'[Year Week],,ASC,Dense) //YYYYWW format

[amitchandak · Accepted solution]

@nesselman , if you want to select 1 week and want to show more than one week. then the slicer need to be on independent

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = _max -108
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

or Use week Rank

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Week Rank])
var _min = _max -13
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Week Rank] >=_min && 'Date'[Week Rank] <=_max))

where Week Rank is a column

Week Rank = RANKX(all('Date'),'Date'[Week Start date],,ASC,Dense)
OR
Week Rank RANKX(all('Date'),'Date'[Year Week],,ASC,Dense) //YYYYWW format

[nesselman · Accepted solution]

Thank you.  Your approach would have gotten me there.  What was important was the Relationship of the 2nd Date table.  PBI was making is a Many-to-Many and Both directions.  I had to fix that to be:  Many-to-One and Single then everything started working.

I also found this page and video good since it is where I saw on his screen that relationship difference.

Showing Results Before Or After A Selected Date Using DAX (enterprisedna.co)

Thank you.