Forum Discussion

singhswat's avatar
singhswat
Frequent Visitor
10 years ago
Solved

Date Comparison

Hi   This might sound silly but I'm not able to get around this problem.   = If (StartDate > Today()) then "Hello" Else "Bye"     Now() / Today () function just doesn't work   Thanks for the...
Need Help
  • Vvelarde's avatar
    Vvelarde
    10 years ago

    Try with this

     

    if [Calendar] > DateTime.Date(DateTime.LocalNow()) then "Hello" else "Bye" )

Vvelarde's avatar
Vvelarde
Community Champion
10 years ago

singhswat

 

The Dax code should be:

 

NameDaxCode= If (StartDate > Today(),"Hello","Bye")

  • singhswat's avatar
    singhswat
    Frequent Visitor
    10 years ago

    Thanks Vvelarde I've tried this 

     

    Error: Expression error: The name 'If' wasn't recognized. Make sure it's spelled correctly.

    • Vvelarde's avatar
      Vvelarde
      Community Champion
      10 years ago

      Are you in Query Editor?

       

       

      • singhswat's avatar
        singhswat
        Frequent Visitor
        10 years ago

        Yes and adding a new column in query editor