Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I'm looking to create a table via DAX that has a range of 1/1/1900 - 12/31/2099, plus one additional date of 12/31/9999. Is this possible?
Solved! Go to Solution.
Hi,
This should do the trick:
DateTable =
UNION(
CALENDAR("01-01-1900", "12-31-2099")
, ROW(
"Date","31-12-9999"
)
)
Hope that helps!
Regards,
Tim
Proud to be a Super User!
Hi,
This should do the trick:
DateTable =
UNION(
CALENDAR("01-01-1900", "12-31-2099")
, ROW(
"Date","31-12-9999"
)
)
Hope that helps!
Regards,
Tim
Proud to be a Super User!
@garynorcrossmmc , you can do that, but then it will create a problem to mark it ar date table
union(calendar(date(1900,01,01), date(2099,12,31)), date(9999,12,31))
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |