Forum Discussion

KristyP's avatar
KristyP
Icon for Helper I rankHelper I
2 years ago

Running Forecast based on Actual data

Hi,   Been working on this one for a while. I will greaty appreciate some assistance. The data I have is: Two data points - with average monthly usage calculated Usage calculated to 31/12/2023 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi KristyP ,

 

You can try below formula:

avg_ =
VAR monthdifference =
    DATEDIFF ( UsageData[2022 Read date], UsageData[2023 Read Date], MONTH )
RETURN
    DIVIDE (
        UsageData[2023 Read Date] - UsageData[2022 Read date],
        monthdifference
    )
ForecastedUsage =
VAR MonthsAhead =
    DATEDIFF ( TODAY (), DATE ( 2023, 12, 31 ), MONTH )
RETURN
    'UsageData'[2023 Usage] + ( 'UsageData'[average_] * MonthsAhead )

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.