Three and Six Months Average

[Gjorge]

Hi All,

Thank you in advance for your help. I'm trying to get the average for the last three months and 6 months. when I applied two different DAX formula, I got blanks.
The first formula was
[3 Month Moving Sum Units Sold] =
CALCULATE([OrderQty],
DATESINPERIOD(Calendar[Date],
LASTDATE(Calendar[Date]),-3, Month
)
)

Second Formula was;
AVERAGEX (
DATESINPERIOD (Calendar[Date],LASTDATE ( Calendar[Date] ),
-90,
DAY
),
[Total Amount]
)

I would like to get the following columns in the pivot table;
Product_ID,Last_3Months,Last_6Months
File Attached.