I have a look with the x weeks of data. It has 5-6 measures.
How the looks is:
The first column is a dimension , the weeks are pivoted. There are 5-6 measures. I want average for the last 4 or 7 weeks ( not rolling average). Is that possible , if yes how?
e.g : Week -> 2-Jan, 9-Jan , 16-Jan, 23-Jan ,30-Jan ,6-Feb ,13-Feb & I want the average of these 7 weeks across 20-Feb week.