Skip to main content
cancel
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.

Reply
henry_s
Regular Visitor

ENDOFMONTH function not working as expected

I created a simple date table as follows:

 

 

 

 

DateTable =
DATATABLE(
    "Date", DATETIME, {
        {"14/2/2024"},
        {"15/2/2024"},
        {"16/2/2024"}
    }
)

 

 

 

Then I created a new column using 

 

 

End of Month = ENDOFMONTH(DateTable[Date])

 

 

 

Result

henry_s_0-1707882031804.png

 

I know I can use EOMONTH which works, but am curious why this doesnt? I expect to get 29 February but it seems like its simply picking the maximum date. Or maybe I failed to understand the documentation

 

 

 

1 ACCEPTED SOLUTION
govindarajan_d
Super User
Super User

Hi @henry_s ,

 

You are right.

The EOMONTH is a date function that returns the last date of the month irrespective of what dates are present in the date table. 

The ENDOFMONTH is a time intelligence function that returns last date in the current context which means for the month and year that corresponds to the row. You can think of it like a max function on date column for the year-month combination. 

 

In documentation, you will find EOMONTH under date and time functions, while ENDOFMONTH in time intelligence functions. Time intelligence functions require a date table to operate to their best efficiency while date and time functions don't necessarily need that. 

View solution in original post

2 REPLIES 2
henry_s
Regular Visitor

Understood thanks @govindarajan_d . Makes sense now, the name is quite misleading.

govindarajan_d
Super User
Super User

Hi @henry_s ,

 

You are right.

The EOMONTH is a date function that returns the last date of the month irrespective of what dates are present in the date table. 

The ENDOFMONTH is a time intelligence function that returns last date in the current context which means for the month and year that corresponds to the row. You can think of it like a max function on date column for the year-month combination. 

 

In documentation, you will find EOMONTH under date and time functions, while ENDOFMONTH in time intelligence functions. Time intelligence functions require a date table to operate to their best efficiency while date and time functions don't necessarily need that. 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.