Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Week Slicer Difference

Good day, guys.   I have sample data about audits of fuel products, among the data being captured is the completion date (when a laserfiche form is submitted online), and a computed database field,...
  • amitchandak's avatar
    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

    https://community.powerbi.com/t5/Desktop/Required-custom-date-Slicer-Last-7-days-last-15-days-last-30/m-p/1284966#M561629