Major bug in ENDOFMONTH function

[rroman12]

So, the problem is that the DAX function <ENDOFMONTH> is returning 30 for December.

A  similar function in Power Query (M language, Date.EndOfMonth function) is returning the correct value (31).

[v-tianyich-msft]

Hi @rroman12 ,

There seems to be no problem, make sure the DAX expression is correct.

Best regards,
Community Support Team_ Scott Chang

[RafaelJJCosta]

Hello,

I was the one that took the screenshot, (Thank you @RR  for posting, by the way :D). So, the code is <

EndOfMonth = ENDOFMONTH(dim_Calendar[Date])>. Nothing fancy, same as yours.

The only difference I spotis that this dax function is being used in a dimension when the problem occurs, while I see that yours is being used in a measure.

The dataset where the problem is happening just refreshed yesterday and the problem remains.

Above we can see the code and the name of the column.

Above, I highlighted one of each (right 2022 and wrong 2023).  This table is a simple calendar table, with all the typical columns we expect to find (weeks, months, monthyears etc.).

Thank you all in adbence for any help!

Rafael