How to get following(prior) 8 weeks of avg data qty in DAX

[Srikantht]

 how to write a measure of average of following(coming) 8 weeks qty for the above data  & I have week end date in calendar . can anyone help for solution? 

[Anonymous · Accepted solution]

Hi  @Srikantht ,

I created some data:

Here are the steps you can follow：

Create measure.

Measure =
var _today=TODAY()
var _week=WEEKNUM(_today,1)
return
AVERAGEX(FILTER(ALL('Table'),'Table'[week]>=_week-8&&'Table'[week]<_week),[rand])

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Srikantht]

Thank you its working

[johnt75]

Assuming that Demand Quantity is a measure, you could try

Avg 8 weeks =
VAR currentEndWeek =
    LOOKUPVALUE ( 'Date'[End of week], 'Date'[Date], TODAY () )
VAR finalEndWeek = currentEndWeek + 56
RETURN
    AVERAGEX (
        ADDCOLUMNS (
            CALCULATETABLE (
                VALUES ( 'Date'[End of week] ),
                'Date'[End of week] >= currentEndWeek
                    && 'Date'[End of week] <= finalEndWeek
            ),
            "@val", [Demand Quantity]
        ),
        [@val]
    )