There's an issue with the DATE function supporting 0 day, which should represent the last day of the previous month. Measure = DATE(2017, 1, 0) The expected outcome on this should be December 31...
I've got response from the Product Team.
DAX DATE function is different from Excel's same named function in that the former only supports valid dates while Excel's version does date shifting if the input parameters correspond to invalid dates. This is by design.
Best Regards,
Herbert