Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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
Solved! Go to Solution.
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.
Understood thanks @govindarajan_d . Makes sense now, the name is quite misleading.
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.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |