Forum Discussion
Value for indefinite future/past dates?
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?
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.)
4 Replies
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
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)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.)
- 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...
