cancel
Showing results for
Did you mean:
Regular Visitor

## 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("3-1-2018");1;if(today()>value("7-2-2018");1;if(today()>value("7-3-2018");1;if(today()>value("4-4-2018");1;if(today()>value("9-5-2018");1;0)))))))

With this formula I want to have a 0 if the dates that I've put in are not later than today's date (17-10-2017).

So for example for the first if formula (IF(today()>value ("8-11-2017");1;0) , I expect to get a 0 since that date is in the future.

Actually all the dates are in the future, so the output should be 0 but it's not working for me.

Cheers,

DSabsi

1 ACCEPTED SOLUTION

Accepted Solutions
Established Member

## Re: IF formula with date and today function

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

4 REPLIES 4
Established Member

## Re: IF formula with date and today function

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

Regular Visitor

## Re: IF formula with date and today function

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

Regular Visitor

## Re: IF formula with date and today function

@erik_tarnvik@alena2k 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

Established Member

## Re: IF formula with date and today function

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.