Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.)
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |