Forum Discussion

brockry1's avatar
brockry1
Icon for Helper II rankHelper II
1 year ago
Solved

Dax Command for Rolling 3 Week Average

I'm looking to calculate a rolling 3 week average on my GSV for the last 3 weeks but need it to lag a week.  For the screen shot I would want an average for weeks 10,9 and 8 and when 11 is completed ...
  • techies's avatar
    techies
    1 year ago

    Hi brockry1 please check this

     

    Rolling_3_Week_Avg =
    VAR CurrentWeek = MAX('Sales'[Sales Week])
    VAR LastCompletedWeek = CurrentWeek - 1


    VAR AvailableWeeks =
    TOPN(3,
    FILTER(ALL('Sales'), 'Sales'[Sales Week] <= LastCompletedWeek),
    'Sales'[Sales Week], DESC
    )

    VAR AvgGSV =
    AVERAGEX(AvailableWeeks, 'Sales'[GSV])

    RETURN
    AvgGSV

v-hashadapu's avatar
v-hashadapu
Icon for Community Support rankCommunity Support
1 year ago

Hi brockry1 ,
I hope the information shared was helpful. If you have any additional questions or would like to explore the topic further, feel free to reach out. If any of the responses resolved your issue, please mark it "Accept as solution" and give it a 'Kudos' to support other members in the community.
Thank you!