Next 3 month Average

[Antmkjr]

PBIX link:

https://drive.google.com/file/d/1UKVVjEndFDuBUnsOAGVbg_CnweY2cR-d/view?usp=sharing

In the file attached, I want to get the average of next 3 months Forecasted payments(excluding current month)

I understand a formula like this will work:
Next 3 month average = CALCULATE (
AVERAGE(‘To Collect’[To Collect] ),
DATESINPERIOD ( ‘Date’[Date], EOMONTH(TODAY(),0), 3, MONTH ))

But , in the current example Forecasted Payments formula is bit complicated, so I don’t know how to make it work in this case.

[mahoneypat]

Please try this measure expression to get the 3 month average.

FP 3 Month =
VAR maxdate =
    MAX ( 'Date'[Date] )
VAR startnextmonth = maxdate + 1
VAR end3month =
    EOMONTH (
        startnextmonth,
        2
    )
RETURN
    CALCULATE (
        AVERAGEX (
            DISTINCT ( 'Date'[MonthInCalendar] ),
            DIVIDE (
                [Incremental POC],
                1 - [LastMonthPOC]
            ) * 474
        ),
        FILTER (
            ALL ( 'Date'[Date] ),
            'Date'[Date] >= startnextmonth
                && 'Date'[Date] <= end3month
        )
    )

Regards,

Pat