How does the CLOSINGBALANCEQUARTER function (DAX) work?

The CLOSINGBALANCEQUARTER function (DAX) evaluates the expression at the last date of the quarter using the current context.



How do you use the CLOSINGBALANCEQUARTER function?

Use the CLOSINGBALANCEQUARTER function if you want to calculate the closing balances on a quarter basis.

This DAX function cannot be used when in DirectQuery mode.

Related Blog Posts




Related Support Forum Posts

Cummulatives Total with time intelligence
Data Modelling base on Custom Time Intelligence Format
Irregular Extract Files & Time Intelligence

Considerations when using the CLOSINGBALANCEQUARTER function

The CLOSINGBALANCEQUARTER has three parameters: the expression that returns a scalar value, the date column, and a Boolean expression that defines the filter to apply in the current context.

Related Video Tutorials

Formula examples using the CLOSINGBALANCEQUARTER function


=CLOSINGBALANCEQUARTER ( SUMX (ProductInventory,[UnitsBalance]*[UnitCost]),ProductInventory[InventoryDate] )

=CLOSINGBALANCEQUARTER(Sum(Sales[Quantity]), Sales[OrderDate])

Related DAX Functions

Time Intelligence Functions

Related Course Modules



Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.

Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide