If statement problem

[AH]

Hi,

I have a expression like this:

if

(Today()-[DAX Service Order Created Date] >1, 'TROUBLE!', 'All is Good! ')

I want to make the expression like:

If  (Today()-[DAX Service Order Created Date] =3 then 'Showw Warning'

If its >3 then show 'Trouble'

And If its ❤️ then show 'All is Good'.

Can i have all these three logic in one if statement?

Thanks,

Ahmed

[Colin-Albert]

Try this

if (Today()-[DAX Service Order Created Date] = 3, 'Show Warning',

    if (Today()-[DAX Service Order Created Date] >1, 'TROUBLE!', 'All is Good! '))

[AH]

Hi Colin,

Anything greater than 1 is showing 'TROUBLE' but whaen its equl to 3 thenit should be showing 'Warning'

Thanks,

Ahmed

[maxgro]

If(Today()-[DAX Service Order Created Date] >3, 'Trouble',

If(Today()-[DAX Service Order Created Date] =3, 'Warning',

  'All Is Good'

)) as Expression

[Colin-Albert]

This should work

if (Today()-[DAX Service Order Created Date] = 3, 'Show Warning',

    if (Today()-[DAX Service Order Created Date] >3, 'TROUBLE!', 'All is Good! '))

[jagan]

Hi,

Try like this

LOAD

*,

If(Today()-[DAX Service Order Created Date] =3, 'Warning',

If(Today()-[DAX Service Order Created Date] >3, 'Trouble',

If(Today()-[DAX Service Order Created Date] <3,  'All Is Good', 'Not Available'

))) as Category

Hope this helps you.

Regards,

Jagan.

[jonathandienst]

Hi

Does [DAX Service Order Created Date] contain a time component? If so, then you will need something like

if (Today()-Floor([DAX Service Order Created Date]) = 3, 'Show Warning',

    if (Today()-[DAX Service Order Created Date] >3, 'TROUBLE!', 'All is Good! '))

HTH

Jonathan