Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

0

Major bug in ENDOFMONTH function

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).pic.png

 

 

Status: Delivered

Hi @rroman12 ,

 

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

vtianyichmsft_0-1702000776057.png

vtianyichmsft_1-1702000790626.png

Best regards,
Community Support Team_ Scott Chang

 

Comments
v-tianyich-msft
Community Support
Status changed to: Delivered

Hi @rroman12 ,

 

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

vtianyichmsft_0-1702000776057.png

vtianyichmsft_1-1702000790626.png

Best regards,
Community Support Team_ Scott Chang

 

RafaelJJCosta
New Member

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.

RafaelJJCosta_0-1702129711125.png

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

RafaelJJCosta_1-1702129855185.png

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