Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

DAX for Prediction

Hi everyone, I’m facing a challenge and would appreciate some guidance. I need to calculate a ratio based on the last three months of data and use that to predict the quantity for the next nine month...
Need Help
  • Kedar_Pande's avatar
    Kedar_Pande
    1 year ago

    Calculate the Last Three Months' Real-Time Quantity:

    LastThreeMonthsQty = 
    CALCULATE(
    SUM(YourData[RealTimeQuantity]),
    DATESINPERIOD(DateTable[Date], MAX(DateTable[Date]), -3, MONTH)
    )

     

    Calculate the Ratio

    Ratio = 
    DIVIDE(
    [LastThreeMonthsQty],
    SUM(YourData[AnnualVolume]),
    0
    )

    Predict Quantity for the Next Nine Months:

    PredictedQtyNextNineMonths = 
    [Ratio] * SUM(YourData[AnnualVolume]) * (9 / 12) // Adjust as necessary based on your prediction logic

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ,

Thanks for rubayatyasmin's and Kedar_Pande 's replies!
Anonymous , please check whether their solutions are what you want? If they help you solve your problem, accept their replies as solutions to help more others facing the same problem to find a solution quickly, thank you very much!
If these responses didn't help you, could you please provide some sample data and your expected results, and could you please describe exactly what kind of calculation process you are referring to when you say you are predicting the next 9 months, please?

Best Regards,
Dino Tao