Forum Discussion
ENDOFMONTH function not working as expected
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.
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.