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

Related DAX 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