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])