Hello
I am trying to calculate a growth model. This model uses the previous days data and multiplies this data with a factor. The result is the prediction of the current day. The next day's prediction uses the result from the previous day and applies the same logic again.
Here is the formula I am currently using but I get this error "A circular dependency was detected: CU - Forecast Model Setup[Model Future Hybrid Hours Build]."
Model Future Hybrid Hours Build =
if (DATEADD ( 'CU - Forecast Model Setup'[Date] , - 1, DAY ) IN VALUES ( 'CU - Forecast Model Setup'[Date] ),
VAR CurrentPlatform = 'CU - Forecast Model Setup'[platform_id]
RETURN
if( 'CU - Forecast Model Setup'[Date] >= TODAY() ,
CALCULATE(
SUM('CU - Forecast Model Setup'[Model Future Hybrid Hours Build]),
FILTER(
'CU - Forecast Model Setup',
'CU - Forecast Model Setup'[Date] = EARLIER('CU - Forecast Model Setup'[Date]) - 1 &&
'CU - Forecast Model Setup'[platform_id] = CurrentPlatform
)
)
*
(1 +
CALCULATE(
SUM('CU - Forecast Model Setup'[Model Expected Daily Forecast Growth]),
FILTER(
'CU - Forecast Model Setup',
'CU - Forecast Model Setup'[Date] = EARLIER('CU - Forecast Model Setup'[Date]) - 1 &&
'CU - Forecast Model Setup'[platform_id] = CurrentPlatform
)
)
)
,
IF( 'CU - Forecast Model Setup'[Date] < TODAY() ,
'CU - Forecast Model Setup'[Actual Hybrid Hours],
0
)
)
, BLANK()
)
In excel I could easily create this model with referencing the formula on the cell above... How could I do this in Powerbi?
Thank you!
