Forum Discussion

fbostan1's avatar
fbostan1
Icon for Helper I rankHelper I
4 years ago
Solved

Need Help with Between statement

I need help with this, I want to write a Dax formula in a new column for (If ORDR_DATE is between Rx Direct and Rx Direct End then "Y" else "N")? I'm referencing to the picture below. I tried ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    fbostan1 

    pls try 

    column = IF(ORDER_DATE>=Rx Direct && ORDER_DATE <= Rx Direct End, "Y", "N")

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
4 years ago

fbostan1 

pls try 

column = IF(ORDER_DATE>=Rx Direct && ORDER_DATE <= Rx Direct End, "Y", "N")