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
kaka's avatar
kaka
Icon for Helper II rankHelper II
9 years ago

But I am not getting any such error. 

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi kaka,

 

Please try to click the Refresh button to refresh the data. Also update the desktop to latest version 2.43.4647.541.

 

You can also create a calculated column to return current date,

 

CurrentDate=Today()

 

Then create a calculated column:

 

IF(DATEVALUE(offer_date) >= CurrentDate, "good job", "")

 

If issue persists, would you please share the screenshots about the DAX and results for our analysis? If possible, please share the .pbix file.

 

Best Regards,
Qiuyun Yu