Value for indefinite future/past dates?

[jcountryman]

Sorry in advance if this is poorly worded:  

Is there a value that can be used as a placeholder for indefinite dates? For example, something like [DATE]>FARFUTURE() that will _always_ be false regardless of [DATE] but where FARFUTURE() a valid date value?

[jcountryman · Accepted solution]

I don't know what's so hard about saying it, but there's no such thing as an indefinite date value in DAX. @Anonymous 's condensending reframing of the problem notwithstanding.

FWIW, it's DATE(9999,12,31). ("Google it." Whatever, man.)

[Anonymous]

@jcountryman

I don't know what's condescending about my answer. I wrote "google for it" meaning that I didn't know the highest value straight away. I myself google for such things. But whatever...

[Anonymous]

Sure, you can use a value for this purpose. Just take the highest possible value of the datetime data type (google for it).

[harshnathani]

Hi @jcountryman ,

Not sure about your usecase. Can you elaborate it a little further.

IF (Table [Date] > TODAY(), 0, 1)

You can also look at thi  blog 

https://community.powerbi.com/t5/Community-Blog/Date-as-Dateadd-Decoding-Date-and-Calendar-5-5-Power...

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)