Monthly target line on graph

[Bronagh.Quinn]

I would like to add a target line to a chart, where the target would be set differently depending on the Month.
So for example. for the month of January the target is 5, for February it is 9, for March it is 10 and so on…
Is it possible to do this using CASE ? Or any other way?
I have set goal lines in the past by defining a new calculated measure and adding one number to it. That works well where the monthly target is always the same.

Any help would be appreciated.
Thanks

[martins.vanags]

Hi,

Yes, you could create a new calculated measure using CASE WHEN… THEN…END

Note that you could approach Month by this formula

CASE 
WHEN
[Time].[Month].currentmember.key = 1
THEN
10
WHEN
[Time].[Month].currentmember.key = 2
THEN
12
END

That should set the goals for January and February

Try the solution described in this community post:

ElseIf / CASE ELSE

Hello everyone, EazyBI is very powerful tool and I am quite new user. Therefore, I would like to ask you for benevolence. I would like to check if there is any options to use ElseIf (or equivalent) in formulas? I have tried to use ELSE CASE or CASE ELSE and none worked. So far I had to create cascading CASE WHEN statements, but it is usually not best practice. Here is example: CASE WHEN [Client].Currentmember.Name = "Client A" THEN 1 ELSE CASE WHEN [Client].Currentmember.Name = "C…

Martins / eazyBI support

[Bronagh.Quinn]

Thank you Martins,
This solves my problem exactly.