cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dsabsi Regular Visitor
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. 

 

 

Your help is appreciated!!

Cheers, 


DSabsi

1 ACCEPTED SOLUTION

Accepted Solutions
erik_tarnvik Established Member
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
erik_tarnvik Established Member
Established Member

Re: IF formula with date and today function

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

alena2k Regular Visitor
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

dsabsi Regular Visitor
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

 

 

 

erik_tarnvik Established Member
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.