Forum Discussion

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

ryan_mayu
4 years ago
fbostan1

pls try

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

2 Replies

ryan_mayu
Super User
4 years ago
fbostan1

pls try

column = IF(ORDER_DATE>=Rx Direct && ORDER_DATE <= Rx Direct End, "Y", "N")
davehus
Memorable Member
4 years ago
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.