DAX Function Guide

OPENINGBALANCEQUARTER
Empty image or helper icon

Sam McKay

CEO & Founder

How does the OPENINGBALANCEQUARTER 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?

A scalar value that represents the expression evaluated at the first date of the quarter in the current context.

Related Blog Posts

Loading

Considerations when using the OPENINGBALANCEQUARTER?

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

Loading

Formula examples using the OPENINGBALANCEQUARTER

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 Courses

Loading