I tryed to search the answer here, in forum, but without success..
I have a column chart with the amount of signed docs W29, W30, ....
Need to show the data of the last 8 calendar weeks INCLUDING today, this week. "Include today" option is only available in Relative Date <Weeks>, not in <Calendar weeks>. I can't use <Weeks> because it shows kind of messy data then. Maybe there is some DAX code to measure? I already have calendarauto table with all week no. and etc created.
Here is 8 last week shown as <Calendar weeks>, but I need to include and week W37 and automatically remove W29.
If now. You need to have a date table with Week and Week Rank. And you will another table for display. Long way.
Week Rank = RANKX(all('Date'),'Date'[Week Start date],,ASC,Dense) // In your case it week number with Year This Week = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank]))) Last Week = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1))