Forum Discussion
Solved
Need help with an IF ... AND ... Statement
If([Reference Date]-[CREATE DATE]>22,
AND([Reference Date]-[CREATE DATE]<31,
"Y",
"N"))) Hello, I am new to writing DAX equations with Power BI and need some hel...
Try
if(and([Reference Date]-[CREATE DATE]>22,[Reference Date]-[CREATE DATE]<31)."Y","N")
Just use the same format, but replace the if(and( with if(or(
:smileyhappy:
Try
if(and([Reference Date]-[CREATE DATE]>22,[Reference Date]-[CREATE DATE]<31)."Y","N")
Thank you so much it worked!
Do you know how to insert the OR operator into a DAX equation?Just use the same format, but replace the if(and( with if(or(
:smileyhappy:
