CLOSINGBALANCEQUARTER DAX Function in Power BI

The CLOSINGBALANCEQUARTER DAX 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: It is an optional parameter. It specifies an expression that specifies a filter to apply to the current context.

Example: Create a measure with name “CLOSINGBALANCEQUARTER Measure”.

DAX

The output of the above dax code is shown below:

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