Forum Discussion
Create measure using factors from table.
Hi! I´ve created this table containing all my my processes and corresponding factors. I want to use factors for each process beacuse when im forecasting i tend to see trends changing on process ...
Hey,
I do not totally understand your requirement, but you may start with this:
ForeCastWithFactors =
CALCULATE(
SUMX('ProcessFactors'[Process],
'ProcessFactors'[ProcessFactor]* [Forecast]
)
)
This creates the product for each Row filtered by the Provess
Hopefully this will get you started
I do not totally understand your requirement, but you may start with this:
ForeCastWithFactors =
CALCULATE(
SUMX('ProcessFactors'[Process],
'ProcessFactors'[ProcessFactor]* [Forecast]
)
)
This creates the product for each Row filtered by the Provess
Hopefully this will get you started
Hi! Sorry for my bad english, hopefully this will clear things up a bit.
My current problem is this measure:
ForeCastWithFactors = SUMX('ProcessFactors'; [forecast] * 'ProcessFactors'[ProcessFactor]) It calculates correctly but it does not
fill my entire calendar for some reason. It only calculates until the end of April. I have no actual data after April.
My first measure "Forecast" however works fine and fills my entire calendar.
Measure: Forecast =
Var D1 = [Result2016]
Var D2 = [Result2017]
RETURN
DIVIDE(D1 + D2; 2; 0)