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)