EOMONTH DAX Function

The EOMONTH function returns the date in datetime format of the last day of the month, before or after a specified number of months.

DAX Syntax EOMONTH(start_date, months)

The function has the following parameters:
• start_date: The start date in datetime format, or in an accepted text representation of a date.
• months: A number representing the number of months before or after the start_date. Note: If we enter a number that is not an integer, the number is rounded up or down to the nearest integer.

Example: The following returns the last date of the current month.

DAX

End date of month = EOMONTH(Sheet1[Dates],0)
EOMONTH dax function