Forum Discussion
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...
Hi, Anonymous
Check out already solved soluton here,
Solved: Re: Prediction - Microsoft Fabric Community
refer: Solved: Prediction calculation - Microsoft Fabric CommunityCalculate 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
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