Hello,
In the below metric I want to use Dec 24 FTE (128.65) as a reference value for the forecasted months based on the metrics CALC_FTE.
I used [Select:Month-1] but it’s only working for the first projected month which is jan 25 but not for the forecasted months.
For example in february and other forecasted months we should have 128.65+24
Thanks for your help
Best answer by CDALMAY
Hi
You could update your formula as follow :
IF('Is actual month ?',
CALC_FTE,
CALC_FTE[FILTER:Month = 'Last December Actual'][REMOVE:Month][ADD:Month]
)Where ‘Last December Actual’ is the following metric which (Data Type : Month and Dimension Version)
Month[ADD:Version][FILTER:Month.'Month of Year' = 'Month of Year'."December" AND 'Is actual month?'][REMOVE LASTNONBLANK:Month]
Given the following assumptions for the last actual month :
Hope that solves your issue.
+13Hey,
What you could do to do this would be to
This could look like this:
IF('Is actual month ?', CALC_FTE, CALC_FTE[SELECT: Month.'Dec 24'][ADD: Month]
Hope this helps!
Hi,
Thanks for your answer.
I did not precise but the last month as a reference value is changing for each Version (dimension: budget 2024,reforecast 2024, budget 2025….)
Your formula is working well only if i have one version.
How can I trick your formula so it works for all the versions ?
Thanks
+14Hi
You could update your formula as follow :
IF('Is actual month ?',
CALC_FTE,
CALC_FTE[FILTER:Month = 'Last December Actual'][REMOVE:Month][ADD:Month]
)Where ‘Last December Actual’ is the following metric which (Data Type : Month and Dimension Version)
Month[ADD:Version][FILTER:Month.'Month of Year' = 'Month of Year'."December" AND 'Is actual month?'][REMOVE LASTNONBLANK:Month]Given the following assumptions for the last actual month :
Hope that solves your issue.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
