Forum Discussion

kaka's avatar
kaka
Icon for Helper II rankHelper II
9 years ago

Compare text with today()

I have a column called offer_date which has the followig value: Wednesday, 27 January, 2016 .   I am trying to compare this date with today's date in power bi DAX formula.     IF(DATEVALUE(offer_...
Need Help
Show and Tell
Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

kaka  The comparison is actually happening!

 

You are not seeing anything because you don't have anything in the [ResultIfFalse] part of the IF function

 

You need to reverse >= to <=

 

 

EDIT: I'm assuming this is an Offer Made on Date so you want to it be less than today indicating that Offer has been made! :smileyhappy: