Week Slicer Difference

[Anonymous]

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, weekstartdate, which is always on a Tuesday. The following are available audit data in May:

Completion date / weekstartdate

2022-05-11 14:51:00 / 2022-05-10 00:00:00.000
2022-05-11 11:42:00 / 2022-05-10 00:00:00.000
2022-05-05 07:32:00 / 2022-05-03 00:00:00.000

When I use date slicers, Last week, Next week, and This week, they each displays different data, as follows:

Last week: May 5 - May 11

Last week

This week: May 8 - May 14

This week

Next week: May 11 - May 17

Next week

I wonder why the audit data on 2022-05-11 14:51:00 was only displayed on Next week filter, and not Last week and This week?

Thanks for the help.

[amitchandak · Accepted solution]

@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

[Anonymous]

Thanks very much for this @amitchandak