Forum Discussion

JorgePereira's avatar
JorgePereira
Helper I
6 years ago

Column comparing dates

Can you help me?
This column does not return the right value:
Consulta = IF(Colabs[Rehire_Date].[Date] <= DATE(YEAR([_Data Relatório]), MONTH([_Data Relatório]), DAY([_Data Relatório])),"OK","NO")
 
This works:
Consulta = IF(Colabs[Rehire_Date].[Date] <= DATE(2015, 4, 2),"OK","NO")
 
Need Help

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    JorgePereira remove the .date from rehire date in your dax expression

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        JorgePereira ok, what is _datarelatio, is it a measure or column, are you adding a measure or column? there could be other reasons why it is not getting calculated