Create Calendar Table with One Dummy Date Out of Range

[garynorcrossmmc]

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?  

[timg · Accepted 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

[garynorcrossmmc]

This worked, thanks @timg!

[amitchandak]

@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))