Rolling 3 months average in Pivot table using Months column available in Pivot table

Hello Experts,

I have a three columns - Created (Dates), feature count and Market.
I have created a Pivot summary based on Market showing summary of features count per Market.

Now I need to create additional column in Pivot column showing last 3 months average of feature month.
I created an additional function in Pivot Data model - 'Rolling Average 3 months'.

Formula:

Please Login or Register  to view this content.

But this for sure is wrong as it is parsing all the dates for every month.

I have a desired output for better clarity of what I am looking (Check column C in Pivot tab).

Also, I need a pivot chart trendline with this rolling average as data points.


Thanks

I have a form with startdate/enddate
the run button loops thru all ,marking records (in 4th column MARK) if it fits the date range.
then pivot on the MARKED records=true

Hi ranman

Sorry I didn't get the solution you proposed.
Is it possible to modify the DAX query in the function to get desired results ?