Forum Discussion

dsabsi's avatar
dsabsi
Advocate I
8 years ago
Solved

IF formula with date and today function

Hello everyone,    I'm struggeling with an IF formula in Power BI and I would appreciate your help.  DateDiff = IF(today()> value(("8-11-2017"));1;if(today()>value("6-12-2017");1;if(today()>value(...
Need Help
  • erik_tarnvik's avatar
    erik_tarnvik
    8 years ago

    Try using DATE(2017,8,11) where you now have value(("8-11-2017")). 

erik_tarnvik's avatar
erik_tarnvik
Solution Specialist
8 years ago

Try using DATE(2017,8,11) where you now have value(("8-11-2017")). 

  • dsabsi's avatar
    dsabsi
    Advocate I
    8 years ago

    erik_tarnvikalena2k thank you!!

    this works perfectly, however I want the formula to show 0 and not 1 because of the fact that today is not later then those dates but this is not working and i tried both < and >  but it still doesn't show the 0 . 

    Does anyone know what I'm doing wrong? 

     

    DateDiff = IF (date(2017;8;11)>today();1;

                      if(date(2017;12;6)>today();1;

                      if(date(2018;1;3)>today();1;

                      if(date(2018;2;7)>today();1;

                      if(date(2018;3;7)>today();1;

                      if(date(2018;4;4)>today();1;

                      if(date(2018;5;9)>today();1;0)))))))

     

    Cheers, 

    DSabsi

     

     

     

    • erik_tarnvik's avatar
      erik_tarnvik
      Solution Specialist
      8 years ago

      date(2017;8;11) is before today and date(2017;12;6) is after so you will get a 1 as a result from this formula.