Forum Discussion
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(...
Try using DATE(2017,8,11) where you now have value(("8-11-2017")).
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