CLOSINGBALANCEYEAR DAX Function

The CLOSINGBALANCEYEAR function evaluates the expression at the last date of the year in the current context.

DAX Syntax CLOSINGBALANCEYEAR(Expression, Dates[, Filter][, Year_end_date])

The function has the following parameters:

• 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.

Example: Create a measure.

DAX