6 Replies Latest reply: Feb 16, 2015 12:26 AM by Jonathan Dienst

# If statement problem

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 <3 then show 'All is Good'.

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

Thanks,

Ahmed

• ###### Re: If statement problem

Try this

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

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

• ###### Re: If statement problem

Hi Colin,

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

Thanks,

Ahmed

• ###### Re: If statement problem

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

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

'All Is Good'

)) as Expression

• ###### Re: If statement problem

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

• ###### Re: If statement problem

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! '))

• ###### Re: If statement problem

Hi,

Try like this

*,

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.