Forum Discussion
jcountryman
Helper I
Helper IValue 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 regar...
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.)
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)