Monthly target line on graph

[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