Weekly sales variance % format Measure

Lynzmaz , Create a date table with following columns

 

new columns
Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)
Week Rank = RANKX(all('Date'),'Date'[Week Start date],,ASC,Dense)
OR
Week Rank = RANKX(all('Date'),'Date'[Year Week],,ASC,Dense) //YYYYWW format

 

then create  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))

 

 

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8

Hi,

Do you have a Calendar Table with a week number column?  If not, please create one.

Hi Lynzmaz ,

 

According to your description, a separate calendar table needs to be created. Then create another column to find the number of days of the week corresponding to the date. The measure created to find the difference between the two weeks corresponds to the following reference:

Num = WEEKNUM('calendar'[Date],2)

M_ = 
VAR a =
    WEEKNUM ( TODAY (), 2 )
RETURN
    CALCULATE ( SUM ( 'Table'[Value] ), a = 'calendar'[Num] )
        - CALCULATE ( SUM ( 'Table'[Value] ), a = 'calendar'[Num] - 1 )

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Lynzmaz ,

 

Sorry, it seems that the link you shared cannot be opened because there are no corresponding permissions. Could you share it again by another way.

 

Looking forward to your reply.

Best Regards,
Henry