Forum Discussion

wkelly1002's avatar
wkelly1002
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 hel...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Try

     

    if(and([Reference Date]-[CREATE DATE]>22,[Reference Date]-[CREATE DATE]<31)."Y","N")

  • Anonymous's avatar
    Anonymous
    8 years ago

    Just use the same format, but replace the if(and( with if(or(

     

    :smileyhappy:

Anonymous's avatar
Anonymous
Not applicable
8 years ago
IF([Reference Date]-[CREATE DATE] >22 && [Reference Date]-[CREATE DATE]<31,       
            "Y",
             "N")

The abve one should work.

 

Thanks

Raj