topic Re: Dynamic title in DAX Commands and Tips

Dynamic title

Anonymous — Tue, 16 Aug 2022 13:26:36 GMT

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

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

Thank you in advance,

Re: Dynamic title

daXtreme — Tue, 16 Aug 2022 14:00:41 GMT

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.

Re: Dynamic title

Anonymous — Tue, 16 Aug 2022 15:15:52 GMT

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