Date Comparison

[singhswat]

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 hepl!

[Vvelarde]

@singhswat

The Dax code should be:

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

[singhswat]

Thanks @Vvelarde I've tried this 

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

[Vvelarde]

Are you in Query Editor?

[singhswat]

Yes and adding a new column in query editor

[Vvelarde · Accepted solution]

Try with this

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

[singhswat]

Gracias @Vvelarde 

Thanks @kcantor

[kcantor]

@singhswat

In Query Editor, capitilaization matters. Use if instead of If in your original statement.

Here is more information on IF http://www.excelguru.ca/blog/2014/08/27/the-if-function-in-power-query/