Calculation of Moving Average depending on the date and other value in the same row

[aar0n]

Hi, I have a similar problem to the following:

https://community.powerbi.com/t5/Desktop/Calculation-of-Moving-Average-depending-on-the-date-and-oth...

The biggest difference that I could not figure out, is that i want the average to be for every value before the current row (whereas in the above example, it is for a 30-day timeframe).

Thank you

[v-yuta-msft · Accepted solution]

@aar0n ,

You need to add an index column and then create a calculate column using DAX like pattern below:

AverageCol =
CALCULATE (
AVERAGE ( TableA[SALES] ),
FILTER (
TableA,
TableA[SKU] = EARLIER ( TableA[SKU] )
&& TableA[Index] <= EARLIER ( TableA[Index] )
)
)

Community Support Team _ Jimmy Tao

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