OPENINGBALANCEQUARTER Function (DAX)
How does the OPENINGBALANCEQUARTER function (DAX) work?
The OPENINGBALANCEQUARTER function (DAX) evaluates the expression in the current context, at the first date of the quarter.
OPENINGBALANCEQUARTER Formula Syntax
OPENINGBALANCEQUARTER(
<expression>,<dates>[,<filter>]
)
How do you use the OPENINGBALANCEQUARTER function?
A scalar value that represents the expression evaluated at the first date of the quarter in the current context.
Related Blog Posts
Related Support Forum Posts
Information – OPENINGBALANCEMONTH, STARTOFMONTH, ENDOFYEAR
Understanding DAX Formula
Developing Complex Dax functions
Considerations when using the OPENINGBALANCEQUARTER function
The dates argument can be any of the following:
- A reference to a date/time column.
- A table expression that returns a single column of date/time values,
- A Boolean expression that defines a single-column table of date/time values.
Related Video Tutorials
Formula examples using the OPENINGBALANCEQUARTER function
The following sample formula creates a measure that calculates the ‘Quarter Start Inventory Value’ of the product inventory.
= OPENINGBALANCEQUARTER (
SUMX(
ProductInventory,ProductInventory
UnitCost]*ProductInventory[UnitsBalance]),
DateTime[DateKey]
)