CLOSINGBALANCEYEAR DAX Function in Power BI

The CLOSINGBALANCEYEAR DAX 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: It is an optional parameter. An expression that specifies a filter to apply to the current context.
• Year_end_date: It is an optional parameter. A literal string with a date that defines the year-end date. The default is December 31.

Example: Let's create a measure with name "CLOSINGBALANCEYEAR Measure".

DAX

The output of the measure is shown below:

Here the total 704 in the CLOSINGBALANCEYEAR Measure column, refers to the latest context i.e 14th August 1991.