Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Formula changing by month

Good Afternoon,

I am trying to recreate a similar figure 

However, i want the formula to return different value accodring to the month on the X axis.
exemple : If( Table[Month]=1|| 2, measure x , if(table [month] =3||4||..||12, measure y ))

Is it possible to create such a measure ? 


Best regards,
K.A

  • Anonymous , You should be

     

    Switch( True(),

    Max(Table[Month])  in {1,2}, [Measure X],

    [Measure Y]

    )

1 Reply

  • Anonymous , You should be

     

    Switch( True(),

    Max(Table[Month])  in {1,2}, [Measure X],

    [Measure Y]

    )