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 fo...
  • 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.

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","")