CLOSINGBALANCEYEAR Evaluates the expression at the last date of the year in the current context.
Expression – An expression that returns a scalar value.
Dates – A column that contains dates.
Filter – (optional) An expression that specifies a filter to apply to the current context.
Year_end_date (optional) A literal string with a date that defines the year-end date. The default is December 31.
A scalar value that represents the expression evaluated at the last date of the year in the current context.