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...
v-haibl-msft
9 years agoMicrosoft Employee
It should be the case when day parameter is zero. According to Microsoft documentation, negative integer is supported in day parameter.
Best Regards,
Herbert