How does the OPENINGBALANCEYEAR function (DAX) work?

The OPENINGBALANCEYEAR function (DAX) evaluates the expression in the current context as at the first date of the year.



How do you use the OPENINGBALANCEYEAR function?

A scalar value which represents the expression evaluated in the current context at the first date of the year.

Related Blog Posts

Related Support Forum Posts

DAX Formula to calculate Cumulative Totals with ClosingBalanceYear Measure
Understanding DAX Formula
Developing Complex Dax functions

Considerations when using the OPENINGBALANCEYEAR 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.

The year_end_date parameter is a string literally of a date, at the same locale as the client’s locale where the workbook was created. The year portion of the date is ignored.

Does not allow this DAX function for use in DirectQuery mode.

Related Video Tutorials

Formula examples using the OPENINGBALANCEYEAR function

The following sample formula creates a measure that calculates the ‘Year Start Inventory Value’ of the product inventory.



Related DAX Functions

Related Course Modules



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