Need help in calulating last two week's sales from today wherein my starting from Saturday

[jhab953]

Need help in calulating last two week's sales from today wherein my week's starting from Saturday

[jhab953]

Many thanks for your support! 🙂

[amitchandak · Accepted solution]

@jhab953 , For Saturday week Refer

Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...
https://medium.com/chandakamit/cheat-sheet-any-weekdays-week-start-date-just-one-variable-apart-6b2e...

Then create a week rank on week start date

Week Rank = RANKX('Date','Date'[Week Start date],,ASC,Dense)

These measures can help
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))

Last 2 weeks = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]>=max('Date'[Week Rank])-1 && 'Date'[Week Rank]<=max('Date'[Week Rank])))