Need Help with Between statement

[fbostan1]

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 to search, couldn't find ways to write between statement in PBI

[ryan_mayu · Accepted solution]

@fbostan1 

pls try 

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

[davehus]

Use Powerquery and create a custom column. if Order_Date >=Rx Direct and Order_Date <=RX Direct End then "Y" else "N" Take note of the lower case in the if statement.