Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
Try using DATE(2017,8,11) where you now have value(("8-11-2017")).
@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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |