DAX for Prediction

[12Pro]

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 months.

Here’s the situation: I have two columns of data: one represents the approximate volume for the whole year, and the other contains the real-time quantity, which gets updated over time. For example, if we are currently in September, I need to calculate the ratio using data from June to August. Based on this ratio, I need to predict the real-time quantity for the upcoming nine months.

Any insights on how I can approach this would be really helpful. Thank you!

[rubayatyasmin · Accepted solution]

Hi, @12Pro 

Check out already solved soluton here, 

Solved: Re: Prediction - Microsoft Fabric Community

refer: Solved: Prediction calculation - Microsoft Fabric Community

[v-junyant-msft]

Hi @12Pro ,

Thanks for rubayatyasmin's and Kedar_Pande 's replies!
@12Pro , 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

[Kedar_Pande · Accepted solution]

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

[rubayatyasmin · Accepted solution]

Hi, @12Pro 

Check out already solved soluton here, 

Solved: Re: Prediction - Microsoft Fabric Community

refer: Solved: Prediction calculation - Microsoft Fabric Community