0

I have a column called as at date that gives a snapshot of sales by countries. I would like to filter out the latest week as a measure "This Week". At the same time I want to see what is the 4 week average across the last 4 as at week to benchmark.

I believe I have to use Max(As At Date) to filter out the latest week revenue.

I tried calculating the 4 week average using :

Last 4 weeks Average = CALCULATE(AVERAGE('Held Sales '[Held NPR TY]), FILTER(ALL('Held Sales'[AsAt Week]),'Held Sales '[AsAt Week]<=max('Held Sales '[AsAt Week])-4 ))

This is a sample of how the data set looks like: enter image description here

Improve this question
Related questions
0
Power BI - Last 4,12 and 26 week Sales
1
Sum of last week's sales for custom 52/53 week date table in Dax
0
calculates the sum of my sales for the past week
Load 3 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.