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]
)

Related DAX Functions

Related Course Modules

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.