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

    If statement problem

    Shan Ahmed

      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