An argument of function 'DATE' has the wrong data type or the result is too large or too small.

[Anonymous]

Hi,

I'm trying to make an calender where the minimm date is fixed and the max dat is comming from a table startingDate ([datumIngang]) this date in this calander may go to one year afther this date.

When i use this ill get an message:

An argument of function 'DATE' has the wrong data type or the result is too large or too small.

The data type of data is correct.

Kalender =

    ADDCOLUMNS(

        CALENDAR(

           DATE(2016, 1, 1) /* startdate */

           , DATE(YEAR(MAX(tablename[DatumIngang])) + 1, MONTH(MAX(tablename[DatumIngang])), DAY(MAX(tablename[DatumIngang]))) /* max date + 1 year */

        )

        , "Jaar"

        , FORMAT([Date], "YYYY")

        , "JaarMaand"

        , FORMAT([Date], "YYYY-MM")

        , "Maandnummer"

        , FORMAT([Date], "MM")

        , "Maand"

        , FORMAT([Date], "MMMM")

    )

[amitchandak · Accepted solution]

@Anonymous , Check this. I tested rest is working

DATE(YEAR(MAX(tablename[DatumIngang])) + 1, MONTH(MAX(tablename[DatumIngang])), DAY(MAX(tablename[DatumIngang])))

hope this date column

create a new measure using this if this is working