Forum Discussion
Week Slicer Difference
- 4 years ago
Anonymous ,It is rolling week, You can see date 11 is included , Choose calendar week
In your calendar, you can week start as tuesday. But you will not be able to set that slicer based on the week start on Tuesday .
In you calendar you need to create a week rank on week start date and then calculate this week vs last and next week
Column
Week Rank = RANKX(all('Date'),'Date'[Week Start date],,ASC,Dense)
measures
This Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))Last Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1))
next Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])+1))
You need your own slicer for this week, last week etc
Anonymous ,It is rolling week, You can see date 11 is included , Choose calendar week
In your calendar, you can week start as tuesday. But you will not be able to set that slicer based on the week start on Tuesday .
In you calendar you need to create a week rank on week start date and then calculate this week vs last and next week
Column
Week Rank = RANKX(all('Date'),'Date'[Week Start date],,ASC,Dense)
measures
This Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))
Last Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1))
next Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])+1))
You need your own slicer for this week, last week etc
Thanks very much for this amitchandak