Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

0
rroman12

Major bug in ENDOFMONTH function

Submitted by on ‎12-07-2023 08:53 AM

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
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎12-07-2023 06:00 PM

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
‎12-09-2023 05:58 AM

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

Idea Statuses