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
