Forum Discussion

dsabsi's avatar
dsabsi
Icon for Advocate I rankAdvocate I
9 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
    9 years ago

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

alena2k's avatar
alena2k
Icon for Resolver IV rankResolver IV
9 years ago

Switch Day and Month and you'll get result you expect; I agree that DATE(Year, Month, Day) is better since DAX will give you a hint