CLOSINGBALANCEQUARTER DAX Function

The CLOSINGBALANCEQUARTER function evaluates the expression at the last date of the quarter in the current context.

DAX Syntax CLOSINGBALANCEQUARTER(Expression, Dates[,Filter])

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.

Example: Create a measure.

DAX

The CLOSINGBALANCEQUARTER function = CLOSINGBALANCEQUARTER(SUM(Sheet8[Annual Income]),'Sheet8'[Year])
CLOSINGBALANCEQUARTER dax function