weekly tracking comparison

[nardtmo]

Hello,

Need help.  Want to track weekly % difference between (average of W8 - W10) and W11,WK12, WK13, and so on. WK is variable not so sure how to write a measure in dax

thanks in advance.

[amitchandak · Accepted solution]

@nardtmo 

Please refer to my file where I have to use week Rank to deal with Last week and rolling weeks.

https://www.dropbox.com/s/d9898a48e76wmvl/sales_analytics_weekWise.pbix?dl=0

[amitchandak · Accepted solution]

@nardtmo 

Please refer to my file where I have to use week Rank to deal with Last week and rolling weeks.

https://www.dropbox.com/s/d9898a48e76wmvl/sales_analytics_weekWise.pbix?dl=0

[nardtmo · Accepted solution]

thanks Amit. Appreciate the help!!!

[Ashish_Mathur]

Hi,

Your question is not clear.  Do you have a calendar table to clearly show the week in which each day falls?