• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Three and Six Months Average

Gjorge

New Member
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.
 

Attachments

  • MovingAvg.xlsx
    627 KB · Views: 8
Back
Top