Predict payment date

Hi mrleijzer 

As for the thread

https://community.powerbi.com/t5/Desktop/Forecasting-payment-date-with-calculated-average/m-p/958893#M459418

my solution is as below, please check if my measures can work better on your example.

Meausres:

days =
IF (
    NOT (
        ISBLANK (
            MAX ( [Payment date] )
        )
    ),
    DATEDIFF (
        MAX ( [Invoice date] ),
        MAX ( [Payment date] ),
        DAY
    ) + 1
)


average = AVERAGEX(FILTER(ALLSELECTED('Table'),[Customer]=MAX([Customer])),[days])

expected date = IF(ISBLANK(MAX([Payment date])),MAX([Invoice date])+[average])

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.