--  DATE and TIME are useful to create DateTime columns
--  A DateTime is a number. Therefore, it is possible to
--  sum the date and the time part.
EVALUATE 
    {
        DATE ( 2020, 10, 15 ),
        TIME ( 22, 45, 30 ),
        DATE ( 2020, 10, 15 ) + TIME ( 22, 45, 30 )
    }

--  When the arguments overflow their range, DATE and TIME
--  behave in different ways:
--
--  DATE adds the excess values to the date, moving time forward
--  TIME adds the excess values, but it does never exceed the day
EVALUATE 
    {
        DATE ( 2020, 10, 32 ),
        DATE ( 2020, 20, 1 ),
        TIME ( 10, 90, 0 ),
        TIME ( 50, 0, 0 )
    }

--  You can use DATE to create a new date, one year later
--  Using built-in functions like EDATE is better, it they are available
EVALUATE 
ADDCOLUMNS(
    TOPN ( 5, VALUES ( 'Date'[Date] ), 'Date'[Date], ASC ),
    "One year later",
        DATE ( 
            YEAR ( 'Date'[Date] ) + 1,
            MONTH ( 'Date'[Date] ),
            DAY ( 'Date'[Date] )
        ),
    "One year later (Using EDATE)",
        EDATE ( 'Date'[Date], 12 )
)