Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
This week: May 8 - May 14
Next week: May 11 - May 17
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.
Solved! Go to 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
@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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
69 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
127 | |
32 | |
27 | |
24 | |
22 |