Forum Discussion

Frequent Visitor

8 years ago

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 help with an IF ... AND ... statemment for a calculated column.

Basically I am trying to write out:

IF (xdate - ydate)>21 days
AND ((xdate - ydate)<31 days

Display "Y"

If not, display "N"

Here is what I have so far

Anonymous
8 years ago
Try

if(and([Reference Date]-[CREATE DATE]>22,[Reference Date]-[CREATE DATE]<31)."Y","N")
Anonymous
8 years ago
Just use the same format, but replace the if(and( with if(or(

:smileyhappy:

Anonymous

Not applicable

IF([Reference Date]-[CREATE DATE] >22 && [Reference Date]-[CREATE DATE]<31,       
            "Y",
             "N")

The abve one should work.

Thanks

Raj