How to get moving average on monthly

Hi Anonymous ,

in the row of the matrix do you want Day and Product or Month and Product?

Hi mangaus1111 

Thank you for you quick response.

Output image is below.
I'd like to get result by monthly and products.

But if the granularity of your report is Product and Month, then you need a simple Averagex. 

HI, mangaus1111 

Sorry, my explanation was not enough
What I'd like to get is "moving" average among this month and previous month by month and product

Hi Anonymous ,

try this measure

Moving Average Last 2 Months = 
VAR _MaxMonth = MAX('Date'[Year*Month])
RETURN
CALCULATE(AVERAGEX('Facts5','Facts5'[Sales]),
           'Date'[Year*Month]>= _MaxMonth -1 && 'Date'[Year*Month] <= _MaxMonth
)

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

mangaus1111 

I wrote this measure as below accordingto your advise

But, result is not as I expected.

It seems that average is calculated on a daily basis not monthly.

mangaus1111 

Thanks a million!

Based on your sample, what I'd like to get is 5.5(average of April 5 and May 6)

mangaus1111 

Sorry I was wrong

What I'd like to get is 12 (average of sum of April "10" and sum of May 14 )