Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamic title

Hi, 

 

I would like to create a dynamic title with several IF function. 

I tried with many formulas like below but they don't work 

 

 

or 

 

 

 

The aim is to integrate this formula just here but the data field is grey (i don't know why)

 

 

Thank you in advance, 

 

  • daXtreme's avatar
    daXtreme
    4 years ago

    Hi there.

     

    No idea why it's grayed out but I can give you a hint regarding writing formulas. Instead of nesting IF's, please use SWITCH. It's easier to read, easier to write and harder to make a mistake.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you ! 

    All is worked ! 

    (Formula + grayed out). 

    Here is the solution for user :

     

    SWITCH(SELECTEDVALUE(Temps[Année]),2023,"∆€ 2022",2022,"∆€ 2021",2021,"∆€ 2020",2019,"∆€ 2018","")

     

     

     

  • daXtreme's avatar
    daXtreme
    Solution Sage
    4 years ago

    Hi there.

     

    No idea why it's grayed out but I can give you a hint regarding writing formulas. Instead of nesting IF's, please use SWITCH. It's easier to read, easier to write and harder to make a mistake.