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

I was able to convert the initial text date to datetime. So from Wednesday, 27 February, 2017 to 02/27/2017 12:00:00 AM .  I went under the modeling tab and changed the data type from text to datetime. 

 

The only problem is that the foloowing is still not working: 

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

 

Note that 02/27/17 is greater than today's date (02/20/17). So, it should be displaying "good job", but it's not. 

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

kaka

This is happening because you have values (more like errors) that cannot be coverted to Date!!!

 

Blanks would not cause this - but text that cannot be coverted to a date say 4/1/

 

 

  • 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