Nathan's avatar
Nathan
Frequent Visitor
9 years ago
Status:
Done

Bug: Date Function Issue

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...
Reports
Nathan's avatar
Nathan
Frequent Visitor
9 years ago

v-haibl-msft,

 

Thanks for getting an answer and a workaround for this defintely helped out. However, I'm not sure I'm completely following on the provided resolution. It sounds like the DATE function in DAX should only work with valid dates, but the DATE DAX function follows the same rules for date shifting as the Excel version with the exception of the 0. Along with the Microsoft documentation using the date shifting features in the examples for the DATE DAX function.

 

 

So for instance, the below DAX calculation would produce a valid date of Decemeber 30, 2016.

 

 

Measure = DATE(2017, 1, -1)

 

Does this mean the above calculation would not be supported? Or just the case when the day parameter is zero?

 

Thanks for all the help,

 

Nathan

 

Completed Ideas