ENDOFYEAR DAX Function

The ENDOFYEAR function returns the last date of the year in the current context for the specified column of dates. A table containing a single column and single row with a date value. For example, if the first input date is 7th June 2008, then the end_of_year is 31st December 2008.

DAX Syntax ENDOFYEAR(dates [,year_end_date])

The function has the following parameters:
• dates: A column that contains dates.
• year_end_date (optional): A literal string with a date that defines the year-end date. The default is December 31. The year portion of the date is ignored.

Example: The following expression creates a measure that returns the end of the fiscal year for the current context.

DAX