ENDOFYEAR function
Description
Returns the last date of the year in the current context for the specified column of dates.
Syntax
ENDOFYEAR (<dates>, [<year_end_date>])
Parameters
Sr.No. | Parameter & Description |
---|---|
1 |
dates A column that contains dates. |
2 |
year_end_date Optional. A literal string with a date that defines the year-end date. If omitted, the default is December 31. |
Return Value
A table containing a single column and a single row with a date value.
Remarks
The dates parameter can be any of the following −
A reference to a date/time column.
A table expression that returns a single column of date/time values.
A Boolean expression that defines a single-column table of date/time values.
Constraints on Boolean expressions −
The expression cannot reference a calculated field.
The expression cannot use CALCULATE function.
The expression cannot use any function that scans a table or returns a table, including aggregation functions.
However, a Boolean expression can use any function that looks up a single value, or that calculates a scalar value.
However, a Boolean expression can use any function that looks up a single value, or that calculates a scalar value.
Example
= ENDOFYEAR (Sales [Date])