CLOSINGBALANCEQUARTER Function (DAX)

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.

CLOSINGBALANCEQUARTER Formula Syntax

CLOSINGBALANCEQUATER(
     <expression>,<dates>[,<filter>]
)

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,ProductInventory[UnitCost]*ProductInventory[UnitsBalance]),DateTime[DateKey])

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

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

Related DAX Functions

Time Intelligence Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


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
Membership