Forum Discussion
weekly tracking comparison
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.
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
thanks Amit. Appreciate the help!!!
3 Replies
Hi,
Your question is not clear. Do you have a calendar table to clearly show the week in which each day falls?
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
thanks Amit. Appreciate the help!!!
